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
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博客 ” ，链接：https://blog.itpub.net/16381228/viewspace-755709/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
控制開發人用使用DDL語句
下一篇：
Oracle啟動、關閉簡單的腳本
请登录后发表评论
登录
全部评论
