RE: Performance Question - High I/O per Insert

  • From: "Gogala, Mladen" <Mladen.Gogala@xxxxxxxx>
  • To: "'mstrickland@xxxxxxxxxxxxx'" <mstrickland@xxxxxxxxxxxxx>
  • Date: Wed, 22 Sep 2004 15:52:50 -0400

Did you run in with event 10046 enabled, on level 8, in order to see
what are you waiting for and which recursive SQL statements are waiting 
for the I/O events? That would  be the 0th thing, even before the first one.


--
Mladen Gogala
A & E TV Network
Ext. 1216


> -----Original Message-----
> From: Mark Strickland [mailto:mstrickland@xxxxxxxxxxxxx] 
> Sent: Wednesday, September 22, 2004 3:42 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Performance Question - High I/O per Insert
> 
> 
> I'm trying to understand why I'm seeing a high number of I/Os 
> for inserts.  Inserts are through SQL*Loader conventional 
> patch.  Average row length is 129 bytes, no longs or blobs.  
> The table has five indexes and each index has a blevel of 2.  
> According to v$sqlarea, each insert uses 650 logical I/Os, 69 
> physical I/Os.  I would expect fewer than 20 I/Os per insert. 
>  There are db file sequential read waits on the data files 
> that make up the index tablespace.  That file system also 
> contains the archived logs.  Not surprised at the contention. 
>  Can someone point me in the right direction to understand this?  Thx.
>  
> 
> Mark Strickland
> 
> Drugstore.com
> 
> Seattle,  WA
> 
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: