Re: rman backup slow

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: