More on rollback
- From: "Michael Kline" <mkline1@xxxxxxxxxxx>
- To: "Oracle-L@Freelists. Org" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 16 Feb 2004 08:29:27 -0500
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@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:
