Re: How to speed up 6678700 patching process

From: John Kanagaraj <john.kanagaraj_at_gmail.com>
Date: Mon, 6 Sep 2010 20:44:44 -0700
Message-ID: <AANLkTi=gVtjx7-n2NnVofqzAqbcxAD5jKBoAMxpNW6bi_at_mail.gmail.com>

Hi Avadhani,

You mention that it runs fine for a while *and then* hangs? Are you monitoring the database during these periods using OEM or any home grown scripts? Specifically, you should look for Wait events such as Lib cache load lock/pin or other situations where one session attempts to change (DDL) an object while another is actively using it. Also check your alert logs, i.e. look for the obvious before you go hunting for the esoteric :)

--

John Kanagaraj <><
http://www.linkedin.com/in/johnkanagaraj http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!) ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **
--

http://www.freelists.org/webpage/oracle-l Received on Mon Sep 06 2010 - 22:44:44 CDT

This message: [ Message body ]
Next message: John Kanagaraj: "Re: Oracle wait interface..bug or expected behavior?"
Previous message: Mark Strickland: "Re: NLS_LANG=AMERICAN_AMERICA.AL32UTF8 in bash script in Cygwin"
In reply to: Avadhani mys: "Re: How to speed up 6678700 patching process"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message