Organizing Tablespaces

Question

How can we organize tablespaces in oracle database?

Hemant Kumar · 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. http://docs.oracle.com/cd/B10500_01/server.920/a96521/tspaces.htm