Home » RDBMS Server » Performance Tuning » Oracle CPU usage Analysis (11g)
Oracle CPU usage Analysis [message #675615] Wed, 10 April 2019 04:46 Go to next message
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.
Re: Oracle CPU usage Analysis [message #675617 is a reply to message #675615] Wed, 10 April 2019 05:16 Go to previous messageGo to next message
cookiemonster
Messages: 13747
Registered: September 2008
Location: Rainy Manchester
Senior Member
Why would you use oracle to work that out rather than server analysis tools?
Re: Oracle CPU usage Analysis [message #675627 is a reply to message #675615] Wed, 10 April 2019 09:17 Go to previous messageGo to next message
BlackSwan
Messages: 26640
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?

Re: Oracle CPU usage Analysis [message #675635 is a reply to message #675615] Thu, 11 April 2019 01:18 Go to previous message
John Watson
Messages: 8075
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.
Previous Topic: Oracle high "cost" SELECT query
Next Topic: Query Taking Alot of time ..Help in Tuning
Goto Forum:
  


Current Time: Sun Dec 08 08:08:31 CST 2019