A nice tip. Atleast can be set on test system for first run of upgrade.
Regards Rafiq
Date: Wed, 10 Sep 2003 08:29:23 -0800
RE: Oracle 11iHeh-heh, imagine you're migrating from 10.7, where you have additional few tens of thousands AutoUpgrade scripts as well...
Btw, I have sometimes used the unsupported _wait_for_sync=false parameter to speed up commits when doing upgrades or extensive patching. You've probably looked into some of those 70000 scripts and seen a lot of DDL (altering tables, adding comments etc..). And every DDL requires at least one commit, some even more. Thus if you see lots of log file sync waits for your AutoPatch sessions you could reduce database patching downtime noticeably using this parameter (the same goes for object recompilation). But as soon your instance crashes you should restore from backup, so this is the downside..
Actually, I'm not recommending anyone to use this parameter, just want to say, sometimes I have reduced Apps patching and upgrade downtime several to many hours using this ;)
Tanel.
From: Hately, Mike (LogicaCMG) [mailto:[EMAIL PROTECTED]
Ha! Tell me about it. I'm at the tail end of an upgrade. Just applying the
unified driver to bring all of the products bang up to date.
Just when you think you're on the home straight. A driver file with 920,000
lines that starts 71,000 scripts.
It's enough to start me drinking!
Mike
_________________________________________________________________
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
