Re: Disk I/O Load Balancing

Wells,

You can just move some datafiles to the second disk. Convention is to keep data and indexes separate, then slowly refine over time to separate disk activity (keep datafiles effected by batch away from those used OLTP etc...).

As with most tuning issues it is a case of gathering information about the database and trying things one at a time. Plenty of good books on the subject :)

J

"Wells" <wshammou-NoSpam_at_optonline.net> wrote in message news:<5DiH8.120655$ja.35434960_at_news02.optonline.net>...
> Hello All,
>
> Our setup is Oracle 8.1.6 on Sun Solaris. 1 Data table made of 8 Data files
> spread across 2 disks, 4 datafiles each.
> Disk IO is by far, highest on the first data file. How can I spread the
> load evenly across all data files on both disks.
>
> Thanks very much.
> Wells...
Received on Fri May 24 2002 - 05:16:03 CDT