RE: Speeding up Oracle application db patching

  • From: John Kanagaraj <john.kanagaraj@xxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 28 Apr 2004 13:58:49 -0700

Fpayne,

If this is a 11.5.x to 11.5.8 upgrade, then this might be a single =
patch,
and you may not be able to merge it... On the other hand, you might =
want to
check Metalink for extra patches that 'patch-the-patch' for recently
discovered issues. A true and tested option is to look for long running =
SQLs
and search using them as a string in (the recently renamed) =
MetaStink.....

John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Disappointment is inevitable, but Discouragement is optional!=20

** The opinions and facts contained in this message are entirely mine =
and do
not reflect those of my employer or customers **

>-----Original Message-----
>From: oracle-l-bounce@xxxxxxxxxxxxx=20
>[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tanel P=F5der
>Sent: Wednesday, April 28, 2004 1:30 PM
>To: oracle-l@xxxxxxxxxxxxx
>Subject: Re: Speeding up Oracle application db patching
>
>
>Hi!
>
>I think you should start with other methods for reducing the=20
>downtime, like
>patch merging etc..
>
>I wouldn't want to mention those parameters here since they're very
>dangerous if any crash should happen and you need recovery.=20
>There are lots
>of people who just try any parameters they see in internet to=20
>make their
>system go faster, without caring about the implications of=20
>these at all...
>
>Anyway, go check my paper about reducing 11i upgrade downtime from
>http://integrid.info and you'll find them there...
>
>Tanel.
>
>----- Original Message -----=20
>From: <fpayne@xxxxxxxxxxxx>
>To: <oracle-l@xxxxxxxxxxxxx>
>Sent: Wednesday, April 28, 2004 10:20 PM
>Subject: Speeding up Oracle application db patching
>
>
>> Some time ago there were some posts that addressed
>> speeding up Oracle application db patching with
>> some init.ora parameters.  A recent practice run of
>> a 11.5.8 upgrade database patch on our system ran for
>> 12hours.  I tried to look in the archive but didn't
>> have any luck, does anyone recall those postings
>> and can you pass that info on to me?
>>
----------------------------------------------------------------
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: