Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Fat Pig Replication

RE: Fat Pig Replication

From: <Stephen.Lee_at_DTAG.Com>
Date: Thu, 15 Apr 2004 23:52:13 -0500
Message-ID: <D6339830FC73944E889CC3CEADDB205B0790933C@bu-dtagpo1.tracs.com>


> -----Original Message-----
> Do you really feel as though the 5.7g resource requirement is all that
> unreasonable?

Yes, this is very unreasonable for a table this size; especially the 4 gig rollback when the table was empty to begin with.

> I have to think that the sorting for the index is causing it.

That was my original thought, and that might still be the case, but v$session_longops and v$sort_usage didn't support that theory. But I might have checked at the wrong time, and what was seen at the time I checked was just an innocent bystander who happened to be in the wrong place at the wrong time. The Ouija board and Magic 8 Ball were consulted, but results were inconclusive.

> We have several 2g datafiles for each of our TEMP and ROLLBACK
> requirements in 8.1.7 databases, and they often autoextend > 20g.

I'm thinking you got some rotten SQL running around. Mebbe a Cartesian join or two. Mebbe some batch jobs in dire need of commit here and there. Seriously. Really. This should not be happening.

> Finally, I must ask how and why you need 120+ database
> instances in this day and age.

Don't have that many. It varies between 60 - 80 Oracle test and development databases depending on what is going on. Everybody likes to have their own sandbox, and we're just fabulously nice guys around here. Don't know how many SQL Server instances are around. Besides I just work here. I get paid. I'm happy.



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 Thu Apr 15 2004 - 23:48:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US