Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C982DC.E0070DBE"
Subject: AW: rman backup slow
Date: Fri, 30 Jan 2009 14:15:51 +0100
Message-ID: <0FCF70745FD57F4F8259112EC5E800A501382436@wscxpr18.fhhnet.stadt.hamburg.de>
In-Reply-To: <666b99c70901292310t451798dblccc4eae8ae940fae@mail.gmail.com>
Thread-Topic: rman backup slow
From: <Jan-Hendrik.Boll@dataport.de>
To: <oracle-l@freelists.org>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: Jan-Hendrik.Boll@dataport.de
------_=_NextPart_001_01C982DC.E0070DBE
Content-Type: text/plain; 
 charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

What are the current wait-events for the rman sessions?
->  select state, seq#, event, seconds_in_wait from v$session_wait where
sid in (<rman1>,<rmann>);
Do you backup on tape, hd or tape library?
Regards, Jan

________________________________

Von: oracle-l-bounce@freelists.org
[mailto:oracle-l-bounce@freelists.org] Im Auftrag von Prasad
Gesendet: Freitag, 30. Januar 2009 08:11
An: ORACLE-L
Betreff: rman backup slow


All,

we have a 170G db on 9.2.0.7(solaris 9)  . and I see that it currently
is taking nearly 10 hour+ to do a rman backup .  when I see this in grid
control I see the rman session keeps waiting  on this sql .=20

SELECT
TO_CHAR(SYSDATE,:"SYS_B_0",:"SYS_B_1"),TO_CHAR(SYSDATE,:"SYS_B_2",:"SYS_
B_3"),
TO_CHAR(SYSDATE,:"SYS_B_4",:"SYS_B_5") FROM X$DUAL

anyone has any similar situation .  appreciate any suggestion.

Thanks in advance

thanks
Prasad=20


------_=_NextPart_001_01C982DC.E0070DBE
Content-Type: text/html; 
 charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR></HEAD>
<BODY>
<DIV dir=3Dltr align=3Dleft><FONT face=3DArial color=3D#0000ff =
size=3D2><SPAN=20
class=3D484251313-30012009>What are the current wait-events for the rman =

sessions?</SPAN></FONT></DIV>
<DIV dir=3Dltr align=3Dleft><FONT><SPAN =
class=3D484251313-30012009></SPAN></FONT><FONT=20
face=3DArial><FONT size=3D2><SPAN class=3D484251313-30012009><FONT=20
color=3D#0000ff>-&gt;&nbsp; </FONT></SPAN>select state, seq#, event,=20
seconds_in_wait from v$session_wait where sid in&nbsp;<SPAN=20
class=3D484251313-30012009>(&lt;rman1&gt;,&lt;rmann&gt;);</SPAN></FONT></=
FONT></DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DArial><FONT size=3D2><SPAN=20
class=3D484251313-30012009>Do you backup on tape, hd or tape=20
library?</SPAN></FONT></FONT></DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DArial><FONT size=3D2><SPAN=20
class=3D484251313-30012009>Regards, Jan</SPAN></FONT></FONT></DIV><BR>
<DIV class=3DOutlookMessageHeader lang=3Dde dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>Von:</B> oracle-l-bounce@freelists.org=20
[mailto:oracle-l-bounce@freelists.org] <B>Im Auftrag von=20
</B>Prasad<BR><B>Gesendet:</B> Freitag, 30. Januar 2009 =
08:11<BR><B>An:</B>=20
ORACLE-L<BR><B>Betreff:</B> rman backup slow<BR></FONT><BR></DIV>
<DIV></DIV>All,<BR><BR>we have a 170G db on 9.2.0.7(solaris 9)&nbsp; . =
and I see=20
that it currently is taking nearly 10 hour+ to do a rman backup .&nbsp; =
when I=20
see this in grid control I see the rman session keeps waiting&nbsp; on =
this sql=20
. <BR><BR>SELECT=20
TO_CHAR(SYSDATE,:"SYS_B_0",:"SYS_B_1"),TO_CHAR(SYSDATE,:"SYS_B_2",:"SYS_B=
_3"),<BR>TO_CHAR(SYSDATE,:"SYS_B_4",:"SYS_B_5")=20
FROM X$DUAL<BR><BR>anyone has any similar situation .&nbsp; appreciate =
any=20
suggestion.<BR><BR>Thanks in advance<BR><BR>thanks<BR>Prasad=20
<BR><BR><BR></BODY></HTML>

------_=_NextPart_001_01C982DC.E0070DBE--
--
http://www.freelists.org/webpage/oracle-l