How can we organize the tablespaces in Oracle database to have maximum performance

  • Interview Candidate
  • 1
  • 1914

Showing Answers 1 - 1 of 1 Answers

todearmurali

  • Sep 27th, 2005
 

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions