Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Performance Question - High I/O per Insert

Performance Question - High I/O per Insert

From: Mark Strickland <mstrickland_at_drugstore.com>
Date: Wed, 22 Sep 2004 12:42:15 -0700
Message-ID: <63A70CA32CEF354892F78EADB13D329702C57D22@seaems005c>


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
Received on Wed Sep 22 2004 - 14:39:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US