Home » RDBMS Server » Performance Tuning » cpu usage during backup (10.2.0.2)
cpu usage during backup [message #379983] Thu, 08 January 2009 16:58 Go to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Experts,
I can tune the queries to avoid cpu usage during peak hours.
Is there anything done to avoid cpu hitting 100% during backup hours.
Is it normal if cpu hit 100% during backup time.
Regards,
Varun Punj,
Re: cpu usage during backup [message #379984 is a reply to message #379983] Thu, 08 January 2009 17:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
What kind of backup?
Where are you backing up to?
Re: cpu usage during backup [message #379995 is a reply to message #379984] Thu, 08 January 2009 18:26 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Thanks for reply Mahesh
I am taking RMAN full backups running for two instances.
I am compressing the backups and the storing on the disk at
database server itself.
Regards,
Varun Punj,
Re: cpu usage during backup [message #380014 is a reply to message #379995] Thu, 08 January 2009 20:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Compression is usually CPU intensive. Check the docs.
Based on your hardware resources, toggle around parallel options.

Re: cpu usage during backup [message #380032 is a reply to message #380014] Thu, 08 January 2009 21:17 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Mahesh,
I dont have enough space to keep the bacups as uncompressed.
Should I go for more CPU or it is normal for server to hit 100%
during backups.
Regards,
Varun Punj,
Re: cpu usage during backup [message #380035 is a reply to message #380032] Thu, 08 January 2009 21:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Disk is way cheaper than CPU.
>>it is normal for server to hit 100%
May be. May not be. None can confirm without known the hardware
configuration, your rman configuration and much analysis.
Re: cpu usage during backup [message #380036 is a reply to message #380035] Thu, 08 January 2009 21:24 Go to previous message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Thanks a lot Mahesh.
Previous Topic: Optimized Query with LIKE Operator (merged)
Next Topic: Select statement is causing performance issue
Goto Forum:
  


Current Time: Mon Dec 05 15:09:15 CST 2016

Total time taken to generate the page: 0.12579 seconds