取出当前会话、指定会话的详细信息 - Oracle-fans - 博客园

--取出当前会话的详细信息

select distinct sess.sid     db_sid,
                sess.serial# db_serial#,
                process.pid  db_process_id,
                process.spid os_process_id,
                sess.program
  from v$mystat stat, v$session sess, v$process process
 where stat.sid = sess.sid
   and sess.paddr = process.addr;

--取出指定会话的详细信息