Home » RDBMS Server » Server Administration » CPU utilization percentage by oracle Service
CPU utilization percentage by oracle Service [message #429445] Tue, 03 November 2009 20:54 Go to next message
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.
Re: CPU utilization percentage by oracle Service [message #429446 is a reply to message #429445] Tue, 03 November 2009 21:07 Go to previous messageGo to next message
BlackSwan
Messages: 24905
Registered: January 2009
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 Go to previous messageGo to next message
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
Re: CPU utilization percentage by oracle Service [message #429452 is a reply to message #429451] Tue, 03 November 2009 22:08 Go to previous messageGo to next message
BlackSwan
Messages: 24905
Registered: January 2009
Senior Member
select table_name, column_name from dba_tab_columns where column_name like '%CPU%';

Re: CPU utilization percentage by oracle Service [message #429458 is a reply to message #429451] Tue, 03 November 2009 23:16 Go to previous messageGo to next message
Michel Cadot
Messages: 63804
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
Re: CPU utilization percentage by oracle Service [message #429638 is a reply to message #429458] Wed, 04 November 2009 21:17 Go to previous messageGo to next message
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
Re: CPU utilization percentage by oracle Service [message #429642 is a reply to message #429638] Wed, 04 November 2009 22:15 Go to previous messageGo to next message
BlackSwan
Messages: 24905
Registered: January 2009
Senior Member
> I'm looking for is something like
What you desire is a figment of your imagination.

Oracle does not store CPU usage on per USER basis.

[Updated on: Wed, 04 November 2009 22:33]

Report message to a moderator

Re: CPU utilization percentage by oracle Service [message #429645 is a reply to message #429638] Wed, 04 November 2009 23:43 Go to previous messageGo to next message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
but what I'm looking for is something like

In this result an output of something?

Regards
Michel
Re: CPU utilization percentage by oracle Service [message #429740 is a reply to message #429645] Thu, 05 November 2009 09:43 Go to previous messageGo to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
That's the Top Consumers per service output from OEM
Re: CPU utilization percentage by oracle Service [message #429741 is a reply to message #429740] Thu, 05 November 2009 10:09 Go to previous messageGo to next message
BlackSwan
Messages: 24905
Registered: January 2009
Senior Member
caprikar wrote on Thu, 05 November 2009 07:43
That's the Top Consumers per service output from OEM


CONGRATULATIONS! You have a solution.
Re: CPU utilization percentage by oracle Service [message #429742 is a reply to message #429740] Thu, 05 November 2009 10:09 Go to previous message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBA_HIST_SERVICE_STAT

Regards
Michel
Previous Topic: Tablespace errors
Next Topic: error ORA-01555 in Oracle 10g
Goto Forum:
  


Current Time: Mon Sep 26 16:11:07 CDT 2016

Total time taken to generate the page: 0.18172 seconds