SELECT   SID, v$session.username 用户名, last_call_et 持续时间, status 状态,
         lockwait 等待锁, logon_time 开始登入时间
    FROM v$session, v$process, v$sqlarea
   WHERE paddr = addr
     AND sql_hash_value = hash_value
   AND status = 'ACTIVE'
     AND v$session.username IS NOT NULL
   and SID='221'
ORDER BY last_call_et DESC; 

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