Database Tuning (MOSC)

MOSC Banner

Relocating data file to balance I/O

edited Jan 14, 2010 8:10PM in Database Tuning (MOSC) 7 commentsAnswered
Hi
 
We have a table with an INDEX on it
Table resides in datafile 'e:\oracle\oradata\apps_data1.dbf'
Index resides in datafile 'e:\oracle\oradata\apps_index1.dbf'

Most of the time the table is access via index lookup (unique and range scan)

we have noticed that most of the time "E" drive has the most I/O
We do have another drive "F" which undergoes minimum amount of I/O

We are thinking of relocating either the table datafile OR the index datafile from E drive to F drive so that
the I/O is more balanced from Disk perspective

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center