How can we organize the tablespaces in Oracle database to have maximum performance?
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Memory Management Job Interview Questions And Answers
