Relocating data file to balance I/O
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
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
0