Re: RMAN performance problems
- From: tim@xxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 27 Sep 2004 11:46:42 -0600 (MDT)
We've seen RMAN consume huge amounts of CPU when BACKUP_TAPE_IO_SLAVES = TRUE.
We set it to FALSE and are living happily ever after with better-behaved, less
hoggish RMAN jobs...
It only slightly improved the speed of backup, but it vastly improved CPU
consumption during backups. Not sure which problem you might be experiencing...
-- Attached file included as plaintext by Ecartis --
-- File: RMAN performance problems
Return-Path: <oracle-l-bounce@xxxxxxxxxxxxx>
Received: from mail.sagelogix.com by ocs.sagelogix.com
with ESMTP id 50210411096306260; Mon, 27 Sep 2004 11:31:00 -0600
Received: by mail.sagelogix.com (Postfix, from userid 16)
id B2DDEA843D; Mon, 27 Sep 2004 11:20:44 -0600 (MDT)
Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180])
by mail.sagelogix.com (Postfix) with ESMTP id A5F6EA8405
for <tim@xxxxxxxxxxxxx>; Mon, 27 Sep 2004 11:14:27 -0600 (MDT)
Received: from localhost (localhost [127.0.0.1])
by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP
id 5C3CD72CA4D; Mon, 27 Sep 2004 12:24:42 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])
by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP
id 20476-08; Mon, 27 Sep 2004 12:24:42 -0500 (EST)
Received: from turing (localhost [127.0.0.1])
by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP
id 414A272CA6E; Mon, 27 Sep 2004 12:24:37 -0500 (EST)
X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Subject: RMAN performance problems
Date: Mon, 27 Sep 2004 10:23:02 -0700
Message-ID: <492F4322B62F3C4CBA5131524867C8E40206A1@xxxxxxxxxxxxxxxxxxxxxxx>
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
Thread-Topic: RMAN performance problems
Thread-Index: AcSktqS1y4mrPkA7RzqFI9cLfe1XFQ==
From: "Randy Samberg" <Randy.Samberg@xxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
X-OriginalArrivalTime: 27 Sep 2004 17:23:03.0070 (UTC)
FILETIME=[A4E523E0:01C4A4B6]
X-archive-position: 10208
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@xxxxxxxxxxxxx
Errors-To: oracle-l-bounce@xxxxxxxxxxxxx
X-original-sender: Randy.Samberg@xxxxxxxxxxxxxx
Precedence: normal
Reply-To: Randy.Samberg@xxxxxxxxxxxxxx
X-list: oracle-l
X-Virus-Scanned: by amavisd-new at freelists.org
X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on mail.sagelogix.com
X-Spam-Status: No, hits=0.0 required=3.0 tests=none autolearn=no version=2.63
X-Spam-Level:
I was wondering if anyone can give me some suggestions on an RMAN =
performance problem we are having. Every time our RMAN backups run, we =
have performance problems with slow logins to one of our databases, =
which lasts approximately 1 to 4 minutes. Due to the fact that the =
problem, and the recovery from the problem happens so quickly, it is =
difficult to pin down. I would appreciate any suggestions on how to =
capture this problem in such a short time. Has anyone experienced =
performance problems when RMAN backups run?
Thank you,
Randy
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
