Home » RDBMS Server » Performance Tuning » Regarding I/O Performance
Regarding I/O Performance [message #196749] Sat, 07 October 2006 00:33 Go to next message
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
Re: Regarding I/O Performance [message #196760 is a reply to message #196749] Sat, 07 October 2006 01:25 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Just create new tbs with locally managed.
1.move object to old to new.
2. rebuild all indexes.
3.set default new tbs.
4.drop old one.

for above operation use
1.exp imp utilities
2.alter table/index... move.

[Updated on: Sat, 07 October 2006 01:26]

Report message to a moderator

Re: Regarding I/O Performance [message #196785 is a reply to message #196749] Sat, 07 October 2006 06:42 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just to add User52's recomendatation:
Create LMT wiht uniform and apropriate extent size.
Previous Topic: i/o and disk planning
Next Topic: Converting Non-Partitioned table to Partition table
Goto Forum:

Current Time: Mon Oct 24 18:45:59 CDT 2016

Total time taken to generate the page: 0.26818 seconds