RE: Fat Pig Replication

From: Michael Fontana <mfontana_at_verio.net>
Date: Thu, 15 Apr 2004 16:25:50 -0500
Message-ID: <007101c42330$398d7230$5d0b0a0a@corp.verio.net>

Sorry for the questions answered with still more questions, but....

What version of Oracle?

Have you considered prebuilding the snapshot via export/import and offline instantiation? This is possible if you pre-create the snapshot log and then fast refresh to catch up after the build. Look up "offline instantiation" in metalink.

Do you really feel as though the 5.7g resource requirement is all that unreasonable? I have to think that the sorting for the index is causing it. We have several 2g datafiles for each of our TEMP and ROLLBACK requirements in 8.1.7 databases, and they often autoextend > 20g. We then resize them as needed.

Finally, I must ask how and why you need 120+ database instances in this day and age. All of the overhead associated with each should be considered a waste of some of these same resources we are discussing here. Things such as TEMP ROLLBACK and SYSTEM overhead redundancy should be eliminated where possible before serious reductionary steps are considered. I do realize sometimes these things are not completely within our control, but the time when such issues come up is great to mention it!

Michael Fontana
Sr. DBA
NTT/Verio

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stephen.Lee_at_DTAG.Com Sent: Thursday, April 15, 2004 11:13 AM
To: oracle-l_at_freelists.org
Subject: Fat Pig Replication

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 - 17:30:17 CDT