Re: Rollback too small... on analyze???

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Sat, 14 Feb 2004 23:28:54 +0800
Message-Id: <5.1.1.6.0.20040214231734.03908008@pop.singnet.com.sg>

Your client might be suffering delayed block cleanout. See Note 40689.1 on MetaLink {or others on this list might be able to explain it better}
Hemant

At 09:28 AM 14-02-04 -0500, you wrote:
>Oracle 8.1.7.4 on HP-UX.
>
>I've got a client trying to insert into large tables in batches of
>5 million rows which is taking about 20 minutes per 5 million. No
>problem there.
>
>The problem seems to be that he runs an analyze compute statistics
>afterwards and about 1 out of 5 times he gets a rollback segment
>too small. I wouldn't think analyze uses rollback.. It happens
>so infrequently and ALWAYS seems to work if they simply run it
>again.
>
>What I suspect, though have no way to prove, is that the rollbacks
>are still dumping out after the last batch of inserts and the
>analyze gets a bit confused on this.
>
>I have suggested they put a 3-5 minute "wait" before they run
>the analyze and see if that clears the problem up.
>
>Is there any firm foundation to this?
>
>What might be cause this?
>
>The only other process running at the time was another insert
>batch on a different table.
>
>
>Michael Kline, Principal Consultant
>Business To Business Solutions, LLC
>Richmond, VA
>804-744-1545
>
>
>
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 24-Jan-04}

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Sat Feb 14 2004 - 09:28:54 CST