Oracle Memory Management Question:
Download Job Interview Questions and Answers PDF
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.
Download Memory Management Interview Questions And Answers
PDF
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? |