OS level CPU check

 CPU Check - GV$SESSION;

OS level CPU check 

col sid format 9999999

col spid format a10

col machine format a25

col username format a15

col "OS User" format a15

col Program format a20

col LOGON_TIME format a30

SELECT s.sid, s.serial#,p.spid "OS Pid",machine, s.username "Username",

s.osuser "OS User", s.program "Program",to_char(s.logon_time, 'dd-mon-yy hh24:mi') LOGON_TIME, a.sql_id,s.PREV_SQL_ID

FROM gv$session s, gv$sqlarea a, gv$process p

WHERE s.sql_hash_value = a.hash_value (+)

AND s.sql_address = a.address (+)

AND s.paddr = p.addr

and s.sid in (select s.sid from gv$session s, gv$process p where s.paddr = p.addr and p.spid in ('16146','422','8201','17056'));

CPU Check - V$SESSION;

col sid format 9999999

col spid format a10

col machine format a25

col username format a15

col "OS User" format a15

col Program format a20

col LOGON_TIME format a30

SELECT s.sid, s.serial#,p.spid "OS Pid",machine, s.username "Username",

s.osuser "OS User", s.program "Program",to_char(s.logon_time, 'dd-mon-yy hh24:mi') LOGON_TIME, a.sql_id,s.PREV_SQL_ID

FROM v$session s, v$sqlarea a, v$process p

WHERE s.sql_hash_value = a.hash_value (+)

AND s.sql_address = a.address (+)

AND s.paddr = p.addr

and s.sid in (select s.sid from v$session s, v$process p where s.paddr = p.addr and p.spid in ('16146','422','8201','17056'));