取出当前会话的sid等 - 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;

posted @ 2016-11-04 17:53  Oracle-fans  阅读(407)  评论(0)  编辑  收藏  举报

刷新评论刷新页面返回顶部