Home » RDBMS Server » Performance Tuning » how to calculate cpu usage of database from statspack report (10.1.0.5.0 , linux)
how to calculate cpu usage of database from statspack report [message #440929] Wed, 27 January 2010 23:38 Go to next message
anwar786
Messages: 25
Registered: May 2009
Location: bangalore
Junior Member
Hi,
can someone explain how much of the system cpu is used by the database(staspack report)


Host CPU(CPUs: Cool

User %System %Idle %WIO %WCPU
40.25 3.97 55.59

Instance CPU
% of total CPU for Instance: 22.10
% of busy CPU for Instance: 49.76
%DB time waiting for CPU - Resource Mgr:

[Updated on: Wed, 27 January 2010 23:44]

Report message to a moderator

Re: how to calculate cpu usage of database from statspack report [message #440930 is a reply to message #440929] Wed, 27 January 2010 23:50 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Understanding CPU
Quote:
IN OEM The Host CPU section provides the overall CPU utilization by the database on the host machine. It also shows theload on the CPU, as well as any paging activity on the host machine


REad the performance guide for more details.....

sriram Smile

Report message to a moderator

Re: how to calculate cpu usage of database from statspack report [message #440931 is a reply to message #440930] Wed, 27 January 2010 23:54 Go to previous message
anwar786
Messages: 25
Registered: May 2009
Location: bangalore
Junior Member
no actually i need the information of cpu utilization from the report that i posted which is a part of statspack report.
the snaps are 1 week old so i cannot use oem now .
can u makeout anything from the report regarding cpu utilization if so reply at the earliest.

Report message to a moderator

Previous Topic: v$pgastat value
Next Topic: Rarely used columns
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 10:33:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.