Re: Inserts are taking time !

On Friday 06 September 2002 19:13, you wrote:
> 2. Commit time - The time for a 'commit' to occur is more a function of the
> number of changes (i.e. table data + each index entry) than the amount of
> data currently in the table/index.

More data in the index means a greater chance on getting index block splits (especially with small block sizes and large keys), and block splits and adding levels will generate more redo and have an effect on the commit time.

Anjo.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anjo Kolk
  INET: anjo_at_oraperf.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).