AW: rman backup slow

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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

Other related posts: