RE: Performance Question - High I/O per Insert

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: