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, tho
I thought I'd repost to see if I could get a response. Anyone?
--- Paul Baumgartel <[EMAIL PROTECTED]> 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 numberin
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