Loading

Organizing Tablespaces

Sonakshi Singh

How can we organize tablespaces in oracle database?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Hemant Kumar14y ago
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
0