Home » RDBMS Server » Performance Tuning » RMAN causing CPU boottleneck
RMAN causing CPU boottleneck [message #267702] Fri, 14 September 2007 05:36 Go to next message
sreehari
Messages: 101
Registered: May 2006
Senior Member
Hi all

Recenly there is a huge bottleneck with the CPU, when i run the ADDM, i found the following informative messages.

Consider not using the compression option for RMAN jobs. Alternatively, consider slowing down RMAN activity, or scheduling RMAN jobs when user activity is lower.

Consider slowing down RMAN activity, or scheduling RMAN jobs when user activity is lower.


can some one tell me what how to deal this case..

Thank you in advance.
Re: RMAN causing CPU boottleneck [message #267747 is a reply to message #267702] Fri, 14 September 2007 11:00 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Always Schedule your backup when there's minimum activity on the database.
Re: RMAN causing CPU boottleneck [message #267748 is a reply to message #267702] Fri, 14 September 2007 11:22 Go to previous message
srinivnp
Messages: 136
Registered: January 2006
Location: stlouis MO USA
Senior Member
How many channels have you open during backup ? Reduce th enumber of channels.

Also consider MINIMIZE LOAD option. Look up the doco for details.

Srini


Previous Topic: problem in insert
Next Topic: Finding Status Progress of Query with Single Block I/O
Goto Forum:
  


Current Time: Sun Dec 04 22:31:13 CST 2016

Total time taken to generate the page: 0.09706 seconds