rman backup slow
Date: Thu, 29 Jan 2009 23:10:59 -0800
we have a 170G db on 188.8.131.52(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 .
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