Re: RMAN 'delete obsolete' command takes ages
From: Ian Chard <ian.chard_at_sers.ox.ac.uk>
Date: Mon, 12 Jan 2009 09:16:35 +0000
Message-ID: <gkf1pk$216$1_at_frank-exchange-of-views.oucs.ox.ac.uk>
On 09/01/09 17:25, Steve Howard wrote:
> On Jan 9, 10:25 am, Ian Chard <ian.ch..._at_sers.ox.ac.uk> wrote:
>
> select inst_id,event,seconds_in_wait from gv$session where program
> like 'rman%';
>
> What does that return?
Date: Mon, 12 Jan 2009 09:16:35 +0000
Message-ID: <gkf1pk$216$1_at_frank-exchange-of-views.oucs.ox.ac.uk>
On 09/01/09 17:25, Steve Howard wrote:
> On Jan 9, 10:25 am, Ian Chard <ian.ch..._at_sers.ox.ac.uk> wrote:
>> Hi, >> >> I'm running Oracle 10g on RHEL 5.2, backing up with RMAN to Tivoli >> Storage Manager. When I run 'delete obsolete', it quickly lists what it >> wants to delete but then just sits there for many tens of minutes, >> occasionally deleting one.
>
> select inst_id,event,seconds_in_wait from gv$session where program
> like 'rman%';
>
> What does that return?
After waiting for a few minutes, that query gives:
1 SQL*Net message from client 201
1 SQL*Net message from client 204
1 Backup: sbtinfo2 198
1 SQL*Net message from client 201
After ten minutes the same four entries are returned, but with larger seconds_in_wait values.
Does this tell us anything useful?
Thanks for any help
- Ian
-- Ian Chard, Senior Unix and Network Gorilla | E: ian.chard_at_sers.ox.ac.uk Systems and Electronic Resources Service | T: 80587 / (01865) 280587 Oxford University Library Services | F: (01865) 242287Received on Mon Jan 12 2009 - 03:16:35 CST