OraFAQ Forum: Performance Tuning » Oracle CPU usage Analysis

Home » RDBMS Server » Performance Tuning » Oracle CPU usage Analysis (11g)

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

Oracle CPU usage Analysis [message #675615]

Wed, 10 April 2019 04:46

s.rangan@outlook.com
Messages: 1
Registered: April 2019

Junior Member

Hi,

How can i get the CPU usage analysis at minute interval in Oracle 11g. can you please help me with the query.

Report message to a moderator

Re: Oracle CPU usage Analysis [message #675617 is a reply to message #675615]

Wed, 10 April 2019 05:16

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Why would you use oracle to work that out rather than server analysis tools?

Report message to a moderator

Re: Oracle CPU usage Analysis [message #675627 is a reply to message #675615]

Wed, 10 April 2019 09:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

s.rangan@outlook.com wrote on Wed, 10 April 2019 02:46

Hi,

How can i get the CPU usage analysis at minute interval in Oracle 11g. can you please help me with the query.

What is OS name & version?

How many different Oracle databases are installed on this system?

which CPU usage value do you desire?

Report message to a moderator

Re: Oracle CPU usage Analysis [message #675635 is a reply to message #675615]

Thu, 11 April 2019 01:18

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

You could query v$sysmetric_history:

orclx> select distinct metric_name from v$sysmetric_history where lower(metric_name) like '%cpu%';

METRIC_NAME
----------------------------------------------------------------
CPU Usage Per Txn
Database CPU Time Ratio
Host CPU Usage Per Sec
CPU Usage Per Sec
Host CPU Utilization (%)
Background CPU Usage Per Sec

6 rows selected.

Report message to a moderator

Previous Topic:	Oracle high "cost" SELECT query
Next Topic:	Query Taking Alot of time ..Help in Tuning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 00:46:11 CST 2025