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 -- //www.freelists.org/webpage/oracle-l