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.

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 08:33:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.