io and cpu on database server

From: Patterson, Joel <Joel.Patterson_at_crowley.com>
Date: Wed, 5 Sep 2012 13:29:59 -0400
Message-ID: <C95D75DD2E01DD4D81124D104D317ACA1C7569B965_at_JAXMSG01.crowley.com>


Say you are backing up your database to another piece of hardware (that does its own compression).

Would there be any IO reflected on the database server (where the datafiles reside) when executing any of the following RMAN maintenance or validation commands?

delete noprompt expired backup;
delete noprompt expired archivelog all;
delete noprompt expired copy;
delete noprompt obsolete;
list backup;
list archivelog all;
restore database validate check logical; restore validate controlfile;
restore validate spfile;

Sometimes I believe DBOptimizer is picking up system io possibly related to these commands.

Joel Patterson
Database Administrator
904 727-2546

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 05 2012 - 12:29:59 CDT

Original text of this message