rman backup slow

  • From: Prasad <p4cldba@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 29 Jan 2009 23:10:59 -0800

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: