Use below query to find the sessions using a lot of CPU.

col program form a30 heading "Program" 
col CPUMins form 99990 heading "CPU in Mins" 
select rownum as rank, a.* 
from ( 
SELECT v.sid, program, v.value / (100 * 60) CPUMins 
FROM v$statname s , v$sesstat v, v$session sess 
WHERE s.name = 'CPU used by this session' 
and sess.sid = v.sid 
and v.statistic#=s.statistic# 
and v.value>0 
ORDER BY v.value DESC) a 
where rownum < 11;
CPUSCRIPT DATABASE SCRIPTS


Related Topics

Script to get cpu usage and wait event information in oracle database
Get sid from ospid
Find the active transactions in oracle database
How to find cpu and memory information of oracle database server
Find sessions consuming lot of CPU
How to find execution history of an sql_id
Find user commits per minute in oracle database
Find pending distributed pending transactions in oracle
How to monitor parallel queries in oracle db
How to get tablespace quota details of an user in oracle

You May Also Like

How to keep or delete columns/Variable of a data frame in R
Shared Pool Advisory in oracle
_use_adaptive_log_file_sync parameter in oracle
Useful flashback related commands
ORA-32771: cannot add file to bigfile tablespace
Script to get cpu usage and wait event information in oracle database
TNS-12542: TNS:address already in use
ENABLE_DDL_LOGGING in oracle 12c
Shell script to monitor asm diskgroup usage
WHAT IS SQL PROFILE IN ORACLE

From This Website

Generate custom report from OEM cloud control
ORA-30034: Undo tablespace cannot be specified as temporary tablespace
EMCLI command - OEM 12C
Shell script to monitor goldengate process
How to enable flash recovery area in oracle database
Find pending distributed pending transactions in oracle
How to move controlfile to a new location in oracle
TRUST_EXISTING_TABLE_PARTITIONS in oracle 12.2 datapump
How to use oratop tool for oracle database monitoring
Exception in thread -main" java.lang.OutOfMemoryError: GC overhead limit exceeded with bsu.sh