RE: rman backup slow

Is cursor_sharing=force set on your db? I don't have time to check if there
is a bug related to this, but since there are so many bugs related to
cursor_sharing=force I just thought I would ask.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Prasad
Sent: January 30, 2009 2:11 AM
To: ORACLE-L
Subject: 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


Other related posts: