More on rollback

From: Michael Kline <mkline1_at_comcast.net>
Date: Mon, 16 Feb 2004 08:29:27 -0500
Message-ID: <IEEDIGCJJAPBLKMIGBPFGEDCJCAA.mkline1@comcast.net>

On some of the tables we are talking some 180+ million rows. There is probably along the line of 16gb of rollback segs.

They do parallel on some of the things, this table I think they do degree 4, but they change things all the time.

We've been experimenting with various options.

They do have nologging turned on. We have up to 20 parallel servers.

It's batch job after batch job that combines records from tables that are perhaps even larger than this to about 8-10 tables from which they make cubes and the like.

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

Received on Mon Feb 16 2004 - 07:29:27 CST