Re: RMAN 'delete obsolete' command takes ages

From: Mladen Gogala <>
Date: Fri, 9 Jan 2009 19:23:04 +0000 (UTC)
Message-ID: <gk886o$p3v$>

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.

Received on Fri Jan 09 2009 - 13:23:04 CST

Original text of this message