InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How Can We Organize The Tablespaces In Oracle Database To Have Maximum Performance? |
|
Answer» STORE DATA in tablespaces to avoid DISK contension.system tablespace-recursive callsuserdata-users objectsindex tablespace-for indexesrollback segmnets-undo tablespace or MANUAL ROLLBACK segmentsplace application specific data in respective tablespaces.Place all these tablespaces in saperate disks.Try to implement raid-0 (striping) for better performance. Store data in tablespaces to avoid disk contension.system tablespace-recursive callsuserdata-users objectsindex tablespace-for indexesrollback segmnets-undo tablespace or manual rollback segmentsplace application specific data in respective tablespaces.Place all these tablespaces in saperate disks.Try to implement raid-0 (striping) for better performance. |
|