Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance on Insert

Re: Performance on Insert

From: Winxxniw <winxxniw_at_aol.com>
Date: 10 Apr 1998 01:20:35 GMT
Message-ID: <1998041001203500.VAA24035@ladder01.news.aol.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US