Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance on Insert
If your tables, indexes, rollback segments and redo are sharing the same disk,
then you could be thrashing on that single disk. Oracle will then be
constrained by the maximum performance of a single disk. Thus, no matter how
many parallel inserts you attempt, the agregate throughput will be the same.
If you are on a unix box try running iostat and look for a disk which is 100% busy. If you find one, chances are you're thrashing and will need to distribute your database among multiple disks. Received on Thu Apr 09 1998 - 20:20:35 CDT