RE: rman backup slow

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Fri, 30 Jan 2009 08:24:29 -0500
Message-ID: <BAY141-DAV2354A2C20D72EC7467621A6C60_at_phx.gbl>
Message-ID: <F626BA5035746548AF2DF3E71FEB5257220BEC4169_at_MBX01.bell.corp.bce.ca>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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

Received on Fri Jan 30 2009 - 07:24:29 CST