OraFAQ Forum: Server Administration » CPU utilization percentage by oracle Service

Home » RDBMS Server » Server Administration » CPU utilization percentage by oracle Service

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

CPU utilization percentage by oracle Service [message #429445]

Tue, 03 November 2009 20:54

caprikar
Messages: 226
Registered: March 2007

Senior Member

Hi,
I have oracle 10g RAC running on HP-UX. We have about 15 database services used for different applications and I want to find how much CPU is consumed say for the last 24 hrs by each of those services. Can someone tell me how to find that?
Thanks.

Report message to a moderator

Re: CPU utilization percentage by oracle Service [message #429446 is a reply to message #429445]

Tue, 03 November 2009 21:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

use "sar" utility

man sar

post results from following:

sar

[Updated on: Tue, 03 November 2009 21:10]

Report message to a moderator

Re: CPU utilization percentage by oracle Service [message #429451 is a reply to message #429446]

Tue, 03 November 2009 21:50

caprikar
Messages: 226
Registered: March 2007

Senior Member

Hi,
I would like to get CPU utilization information from oracle side which can give me based on services and not from OS side.
Thanks

Report message to a moderator

Re: CPU utilization percentage by oracle Service [message #429452 is a reply to message #429451]

Tue, 03 November 2009 22:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

select table_name, column_name from dba_tab_columns where column_name like '%CPU%';

Report message to a moderator

Re: CPU utilization percentage by oracle Service [message #429458 is a reply to message #429451]

Tue, 03 November 2009 23:16

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

select * from dict where lower(comments) like '%cpu%' or table_name like '%CPU%';

Regards
Michel

Report message to a moderator

Re: CPU utilization percentage by oracle Service [message #429638 is a reply to message #429458]

Wed, 04 November 2009 21:17

caprikar
Messages: 226
Registered: March 2007

Senior Member

Hi,
Thank you all for your response, but what I'm looking for is something like

Service Name CPU%
---------------------
HR 51.15
GWB 8.49
SYS$BACKGROUND 16.6
SYS$USERS 7.75
PURGE 7.33
MAINTAIN 2.86
PL 2.49
STAR 1.92
ATM 0.57
GOLDG 0.44
Other 0.3
total 99.9

Thanks

Report message to a moderator