Re: RMAN 'delete obsolete' command takes ages
Date: Fri, 9 Jan 2009 19:23:04 +0000 (UTC)
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