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

  • From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sat, 14 Feb 2004 23:28:54 +0800

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@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at //www.freelists.org/archives/oracle-l/
>FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: