Re: RMAN 'delete obsolete' command takes ages
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Fri, 9 Jan 2009 19:23:04 +0000 (UTC)
Message-ID: <gk886o$p3v$1_at_ss408.t-com.hr>
On Fri, 09 Jan 2009 15:25:35 +0000, Ian Chard wrote:
Date: Fri, 9 Jan 2009 19:23:04 +0000 (UTC)
Message-ID: <gk886o$p3v$1_at_ss408.t-com.hr>
On Fri, 09 Jan 2009 15:25:35 +0000, Ian Chard wrote:
> strace tells me that the rman process is blocked reading from an oracle
> process, which seems to be doing nothing much. What can I do to find
> out why this takes so long?
V$SESSION_WAIT and V$SESSION_EVENT can both provide useful clues.
>
> Many thanks for any advice
> - Ian (not a DBA, and please don't tell me to hire one!)
Get OEM with the diagnostic and tuning packages. That will make you a DBA 2.0.
-- http://mgogala.freehostia.comReceived on Fri Jan 09 2009 - 13:23:04 CST