AW: rman backup slow

From: <Jan-Hendrik.Boll_at_dataport.de>
Date: Fri, 30 Jan 2009 14:15:51 +0100
Message-ID: <0FCF70745FD57F4F8259112EC5E800A501382436_at_wscxpr18.fhhnet.stadt.hamburg.de>

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_at_freelists.org
[mailto:oracle-l-bounce_at_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 .

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

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

Received on Fri Jan 30 2009 - 07:15:51 CST