Oracle Memory Management Question:
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.
| Previous Question | Next Question |
| How will you force database to use particular rollback segment? | How will you swap objects into a different table space for an existing database? |