Re: rman backup slow
- From: Jared Still <jkstill@xxxxxxxxx>
- To: p4cldba@xxxxxxxxx
- Date: Fri, 30 Jan 2009 22:49:52 -0800
On Fri, Jan 30, 2009 at 8:45 PM, Prasad <p4cldba@xxxxxxxxx> wrote:
> my apologies for the late response. To answer this . not it is not a
> new database . it has been in production since last couple of years. it
> hosts a application which has lot of LONG RAW data . it is right now 170GB .
> out of which the LONG RAW table only occupies 80GB. The RMAN backup is
> taken connected to recover catalog . The backup goes to disk . right now
> the cursor_sharing is set to similar . The most significant wait I see is
> disk async i/o . This is a solaris server with vxfs and it do not support
> async i/o .
>
> The puzzling factor is the select on x$dual which just sits silently for
> hours. and the entire backup duration goes beyond 10 hour .
>
What exactly is it waiting on ?
select
s.username username,
e.event event,
s.sid,
e.p1text,
e.p1,
e.p2text,
e.p2,
e.seq# seq,
e.wait_time,
e.seconds_in_wait,
e.state
from v$session s, v$session_wait e
where s.username is not null
and s.sid = e.sid
and s.username like upper('&uusername')
order by s.username, upper(e.event)
Jared
Other related posts:
