RE: rman backup slow
- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
- To: "'ORACLE-L'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 30 Jan 2009 08:24:29 -0500
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: