Re: rman backup slow

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 30 Jan 2009 22:49:52 -0800
Message-ID: <bf46380901302249v60718419me354ae406cc6ce74_at_mail.gmail.com>

On Fri, Jan 30, 2009 at 8:45 PM, Prasad <p4cldba_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Jan 31 2009 - 00:49:52 CST