RE: [EXTERNAL] Sudden Backup Slowdown

From: Khan, Muhammad <MKhan16_at_northwell.edu>
Date: Mon, 4 Nov 2019 14:56:52 +0000
Message-ID: <BN7PR19MB2227011B8A08B15CBBA18EE8BB7F0_at_BN7PR19MB2227.namprd19.prod.outlook.com>



How about the thing called network? ☺

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Charlotte Hammond Sent: Monday, November 04, 2019 9:22 AM To: ORACLE-L <oracle-l_at_freelists.org> Subject: [EXTERNAL] Sudden Backup Slowdown

External Email. Use Caution.
Hello All,

I'm trying to explain why my level 0 rman backups have suddenly jumped from 8hours to 12 hours. The size of the backup has barely changed and there has been no configuration changes. AWR and O/S statistics show that CPU for all the channels are maxed out at ~99% (presumably backup compression) for most of this time, both in the 8 hour case and 12 hour case. The server itself has no other activity during the backup window.

This is on 11.2.0.4 on AWS EC2 backing up to S3 storage.

I'm not looking for tuning advise here (thanks though!) - I'm really hoping for some advise on finding an explanation for the change in times. Given that all it's doing is sitting on CPU I'm not sure what else I can investigate - especially with limited ability to cross-reference it with the "good old" runs. It's been 8 hours for months and months, and has now been 12 hours for the last 3 weeks. There was no gradual increase - just a step change.

Thanks!
Charlotte

The information contained in this electronic e-mail transmission and any attachments are intended only for the use of the individual or entity to whom or to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this communication is not the intended recipient, or the employee or agent responsible for delivering this communication to the intended recipient, you are hereby notified that any dissemination, distribution, copying or disclosure of this communication and any attachment is strictly prohibited. If you have received this transmission in error, please notify the sender immediately by telephone and electronic mail, and delete the original communication and any attachment from any computer, server or other electronic recording or storage device or medium. Receipt by anyone other than the intended recipient is not a waiver of any attorney-client, physician-patient or other privilege.

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 04 2019 - 15:56:52 CET

Original text of this message