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_at_drugstore.com]
> Sent: Wednesday, September 22, 2004 3:42 PM
> To: oracle-l_at_freelists.org
> 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
Received on Wed Sep 22 2004 - 14:48:40 CDT
