sqlplus /nolog < connect / as sysdba
col machine format a30
col program format a40
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
col machine format a30
col program format a40
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-715625/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16381228/viewspace-715625/