rman backup slow

From: Prasad <p4cldba_at_gmail.com>
Date: Thu, 29 Jan 2009 23:10:59 -0800
Message-ID: <666b99c70901292310t451798dblccc4eae8ae940fae_at_mail.gmail.com>

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 - 01:10:59 CST

This message: [ Message body ]
Next message: Martin Berger: "Re: Weird connectivity problem."
Previous message: Tanel Poder: "RE: Autonomous transaction not committed"
Next in thread: Jan-Hendrik.Boll_at_dataport.de: "AW: rman backup slow"
Reply: Jan-Hendrik.Boll_at_dataport.de: "AW: rman backup slow"
Reply: Michael McMullen: "RE: rman backup slow"
Maybe reply: Fuad Arshad: "Re: rman backup slow"
Maybe reply: Robert Freeman: "Re: rman backup slow"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message