根據PID查找用戶登錄Oracle信息及當前運行的SQL語句

csdnww1209

于 2013-03-11 08:29:02 发布

阅读量66

点赞数

sqlplus /nolog <   connect / as sysdba
   col machine format a30
   col program format a40
   col osuser format a20
   col MACHINE format a25
   set line 200

   select sid,serial# ,username,osuser,machine,program,process,to_char(logon_time,'yyyy/mm/dd hh24:mi:ss')
     from v\$session
    where paddr in
                ( select addr from v\$process where spid in($1));

   SELECT sql_text
     FROM v\$sqltext a
     WHERE a.hash_value = (SELECT sql_hash_value
                             FROM v\$session b, v\$process c
                            WHERE b.paddr = c.addr
                              AND c.spid=$1)
                            ORDER BY piece ASC ;
exit;
EOF

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16381228/viewspace-755709/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16381228/viewspace-755709/