Re: Oracle 11i

[Tanel Poder]

Title: RE: Oracle 11i

Heh-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.       -----Original Message----- From: Hately, Mike (LogicaCMG) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 10, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 11i 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