Re: RMAN performance problems

From: <tim_at_sagelogix.com>
Date: Mon, 27 Sep 2004 11:46:42 -0600 (MDT)
Message-ID: <6923531.1096307202091.JavaMail.oracle@ocs.sagelogix.com>

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_at_freelists.org> 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_at_sagelogix.com>; 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_at_ussunex1.palmsource.com> X-MS-Has-Attach:
X-MS-TNEF-Correlator:
Thread-Topic: RMAN performance problems
Thread-Index: AcSktqS1y4mrPkA7RzqFI9cLfe1XFQ== From: "Randy Samberg" <Randy.Samberg_at_palmsource.com> To: <oracle-l_at_freelists.org>

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_at_freelists.org
Errors-To: oracle-l-bounce_at_freelists.org X-original-sender: Randy.Samberg_at_palmsource.com Precedence: normal
Reply-To: Randy.Samberg_at_palmsource.com

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
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Mon Sep 27 2004 - 12:50:23 CDT