SELECT /*+ ordered */
 p.spid,
 s.sid,
 s.serial#,
 s.username,
 TO_CHAR(s.logon_time, 'mm-dd-yyyy hh24:mi') logon_time,
 s.last_call_et,
 st.value,
 s.sql_hash_value,
 s.sql_address,
 sq.sql_text
  FROM v$statname sn, v$sesstat st, v$process p, v$session s, v$sql sq
 WHERE s.paddr = p.addr
   AND s.sql_hash_value = sq.hash_value
   and s.sql_Address = sq.address
   AND s.sid = st.sid
   AND st.STATISTIC# = sn.statistic#
   AND sn.NAME = 'CPU used by this session'
   AND p.spid = &osPID -- parameter to restrict for a specific PID 
   AND s.status = ‘ACTIVE’
 ORDER BY st.value desc

版权声明：本文为博主原创文章，未经博主允许不得转载。