| Regarding I/O Performance [message #196749] |
Sat, 07 October 2006 00:33  |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
I have identified that two tablespaces in which indexes and tables exist
i have observed that no. of i/o are occuring on these tablespaces
I need to reduce contention on a tablespace (in which tables exist) because it has only one datafile on a disk in which all of the other oracle files exist
Another problem with this tablespace is that it is a dictionary managed tablespace
i have a plan to create a new tablespace(locally managed) with two datafiles each on a separate disk
then move all of the objects exist in a tablespace having i/o contention
then drop the old tablespace
is it beneficial for me ragarding i/o performance
i want to confirm that when i move these objects to a newly created tablespace then what will be distribution for the objects
will these objects go in each of the datafile which the newly created tablespace has when i move objects in a tablespace?
I am in some trouble
Please help me in this regard
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
