查看连接状态、问题电脑等信息:
select sid,serial#,username,program,machine,status from v$session;
2、查看sql;
select sql_text, count(*) from v$sql s, v$session se where se.prev_hash_value=s.hash_value and se.status='INACTIVE' group by sql_text;
查看连接状态、问题电脑等信息:
select sid,serial#,username,program,machine,status from v$session;
2、查看sql;
select sql_text, count(*) from v$sql s, v$session se where se.prev_hash_value=s.hash_value and se.status='INACTIVE' group by sql_text;