OraFAQ Forum: Performance Tuning » cpu usage during backup

Home » RDBMS Server » Performance Tuning » cpu usage during backup (10.2.0.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

cpu usage during backup [message #379983]

Thu, 08 January 2009 16:58

varunvir
Messages: 389
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,

Report message to a moderator

Re: cpu usage during backup [message #379984 is a reply to message #379983]

Thu, 08 January 2009 17:05

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

What kind of backup?
Where are you backing up to?

Report message to a moderator

Re: cpu usage during backup [message #379995 is a reply to message #379984]

Thu, 08 January 2009 18:26

varunvir
Messages: 389
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,

Report message to a moderator

Re: cpu usage during backup [message #380014 is a reply to message #379995]

Thu, 08 January 2009 20:24

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: cpu usage during backup [message #380032 is a reply to message #380014]

Thu, 08 January 2009 21:17

varunvir
Messages: 389
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,

Report message to a moderator

Re: cpu usage during backup [message #380035 is a reply to message #380032]

Thu, 08 January 2009 21:21

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: cpu usage during backup [message #380036 is a reply to message #380035]

Thu, 08 January 2009 21:24

varunvir
Messages: 389
Registered: November 2007

Senior Member

Thanks a lot Mahesh.

Report message to a moderator

Previous Topic:	Optimized Query with LIKE Operator (merged)
Next Topic:	Select statement is causing performance issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 01 23:00:58 CDT 2024