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