Home » RDBMS Server » Performance Tuning » High CPU Utilizaion (10.2.0.2)
High CPU Utilizaion [message #355120] Wed, 22 October 2008 14:06 Go to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Experts,
I am getting following in ADDM Report:-
Time spent on the CPU by the instance was responsible
 for a substantial part of database time.
Wait class "User I/O" was consuming significant database time.
How could i know the reason behind high CPU Utilizaion and
high User I/O.

Regards,
Varun Punj,
Re: High CPU Utilizaion [message #355122 is a reply to message #355120] Wed, 22 October 2008 14:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Bad SQL.

Regards
Michel
Re: High CPU Utilizaion [message #355356 is a reply to message #355122] Thu, 23 October 2008 16:18 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Michel,
Bad SQL is not responsible for high CPU Utilization in this case.
Instead "Logminer" processes and "STREAMS Capture" is responsible
for high cpu utilization.Can you give me any suggesions or
document so that I could investigate why Logminer process and
STREAMS Capture process is utilizing large amount of CPU.
I have one more question:-
Everytime I am running ADDM Report after taking AWR it is giving me following statement in the end:-
WARNING: The optimal SGA size could not be determined because of incomplete AWR snapshots.
But I want ADDM to determine optimal SGA Size.How can i acheive this
Regards,
Varun Punj,

Re: High CPU Utilizaion [message #355357 is a reply to message #355122] Thu, 23 October 2008 16:23 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Michel,
Bad SQL is not responsible for high CPU Utilization in this case.
Instead "Logminer" processes and "STREAMS Capture" is responsible
for high cpu utilization.Can you give me any suggesions or 
document so that I could investigate why Logminer process and
STREAMS Capture process is utilizing large amount of CPU.
I have one more question:-
Everytime I am running ADDM Report after taking AWR it is giving me following statement in the end:-
WARNING: The optimal SGA size could not be determined because of incomplete AWR snapshots.
But I want ADDM to determine optimal SGA Size.How can i acheive this
Regards,
Varun Punj,

Re: High CPU Utilizaion [message #355404 is a reply to message #355356] Thu, 23 October 2008 23:21 Go to previous message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you hide information we can't give you correct diagnosis.

Regards
Michel
Previous Topic: oracle volume
Next Topic: Do you know how to find out the underlying tables for a dynamic view?
Goto Forum:
  


Current Time: Mon Nov 04 06:31:21 CST 2024