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 > > > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l