Re: High current mode buffer gets on insert

2003-03-14 Thread Paul Baumgartel
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 numbering

High current mode buffer gets on insert

2003-03-13 Thread Paul Baumgartel
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.