Re: High current mode buffer gets on insert

Current mode gets for index inserts is one option. Another cause of CU gets is from checking referential integrity. The block holding the parent key is acquired in current mode as the child row is inserted. There is an optimisation to reduce this effect in arrays/select inserts in Oracle 9, though.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Now available One-day tutorials:
  Cost Based Optimisation
  Trouble-shooting and Tuning
  Indexing Strategies

(see http://www.jlcomp.demon.co.uk/tutorial.html )

____UK_______April 8th
____UK_______April 22nd

____Denmark May 21-23rd

____USA_(FL)_May 2nd

Next dates for the 3-day seminar:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____UK_(Manchester)_May
____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: 14 March 2003 16:43

> I thought I'd repost to see if I could get a response. Anyone?
>
>
> --- Paul Baumgartel <treegarden_at_yahoo.com> wrote:
> > I'm looking at a client's tkprof output, showing among other
things
> > that the insertion of about 135,000 rows taking 450 seconds of
CPU,
> > and
> > with current mode buffer gets numbering almost 800,000. This is a
> > daily warehouse load process, and I know that indexes are left in
> > place
> > during the load. Am I correct in concluding that the high CPU,
and
> > especially the current mode block gets numbering over 6 times the
> > number of rows inserted, are due to index updates?
> >

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).