Warning: session_start(): open(/tmp/sess_dn311lnlsn92jm07flm68c1pc1, O_RDWR) failed: No space left on device (28) in /razi/eraazi/darbari/mercy/index.php on line 15
EraAzi | Find sessions consuming lot of CPU Find sessions consuming lot of CPU

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;

Related Topics

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

You May Also Like

oracleasm utility for ASMLIB
Shell script to monitor lag in standby datbase using dgmgrl
Defgen utility in Oracle goldengate
oraversion utility in oracle 18c - New feature
Purge AUD$ table using DBMS_AUDIT_MGMT
How to move controlfile to a new location in oracle
Find the active transactions in oracle database
Perform Flashback in pluggable database(PDB) in oracle 12.2
Clone a database using dbca command in oracle 19c -New feature
ENABLE_PARALLEL_DML hint in oracle 12c

From This Website

Open wallet automatically after starting the database
Create, configure and mount a Linux file system on Oracle VM
How to Downgrade oracle 19C Grid to 12C GRID
ORA-32773: operation not supported for smallfile tablespace
Standby redologs in oracle dataguard
Setting up Table replication in oracle goldengate
ORA-30034: Undo tablespace cannot be specified as temporary tablespace
Exception in thread -main" java.lang.OutOfMemoryError: GC overhead limit exceeded with bsu.sh
ERROR: No checkpoint table specified for ADD REPLICAT