Re: rman backup slow
From: Jared Still <jkstill_at_gmail.com>
Date: Sun, 1 Feb 2009 11:35:02 -0800
Message-ID: <bf46380902011135h20b14339j37eedbd0bc23478f_at_mail.gmail.com>
On Sat, Jan 31, 2009 at 9:37 PM, Prasad <p4cldba_at_gmail.com> wrote:
Date: Sun, 1 Feb 2009 11:35:02 -0800
Message-ID: <bf46380902011135h20b14339j37eedbd0bc23478f_at_mail.gmail.com>
On Sat, Jan 31, 2009 at 9:37 PM, Prasad <p4cldba_at_gmail.com> wrote:
> There is a device parallelism set to 2 for this rman backup. could it be
> this which makes a sqlnet message from client wait and wait for the spawning
> processes . because 7 hour seems right to my understanding . as the backup
> started at 9pm and I did the output around 4am in the morning . Yes this is
> a backup that goes to disk.
>
Could be.
I started a backup before replying to see if that was the case, and there was no 'sqlnet waiting for client' on any session.
This was a tape based backup.
Could be that there is such a session on disk based.
Sorry, too lazy to set up a disk based backup to check.
Jared
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Feb 01 2009 - 13:35:02 CST