RE: Speeding up Oracle application db patching

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Wed, 28 Apr 2004 13:58:49 -0700
Message-ID: <35CFD500D7BDCE43B9030BBA5979DC18015A35B9@ussccem13.hds.com>

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_at_freelists.org=20
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tanel P=F5der
>Sent: Wednesday, April 28, 2004 1:30 PM
>To: oracle-l_at_freelists.org
>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_at_adelphia.net>
>To: <oracle-l_at_freelists.org>
>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_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 Wed Apr 28 2004 - 15:52:07 CDT