| Help - Object Creation and I/O reduction [message #181427] |
Mon, 10 July 2006 01:48  |
kumarsz
Messages: 180
Registered: March 2005
Location: canada
|
Senior Member |
|
|
Hi,
Oracle9i Enterprise Edition Release 9.2.0.6.0
To reduce I/O contention and get good performance which option is best among the following for creating objects in two
different environments - 1) Using SAN 2)not using SAN
file same tablespace same disk same
file different tablespace different disk same
file different tablespace different disk different
Thanks and Regards,
Pratap
|
|
|
|
| Re: Help - Object Creation and I/O reduction [message #181522 is a reply to message #181427] |
Mon, 10 July 2006 06:56  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
SAN or NOT SAN,
all your disk are striped/mirrored. Right?
Seperating table and index in different tablespaces does not help much (for performance.But very useful for administration. still, you need to keep the individual datafiles across multiple disks).
I would group them based onn application/volume etc.
All lookup tables/ small tables in a small_tablespace, large tables in a large_tablespace (Ofcourse on different disks.)
I would also consider my backup options.Having objects in seperate tablespaces, facilitate backup windows.
>>file different tablespace different
You cannot control or make an object to goto a particular datafile.
All you can do is, place the object in a particular tablespace.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
