SELECT SID,USERNAME,STATUS,LOGON_TIME,LAST_CALL_ET FROM V$SESSION;
select sid,username,status,last_call_et from v$session where status='INACTIVE' order by last_call_et desc;last_call_et は秒。
SELECT SID,USERNAME,STATUS,LOGON_TIME,LAST_CALL_ET FROM V$SESSION;
select sid,username,status,last_call_et from v$session where status='INACTIVE' order by last_call_et desc;last_call_et は秒。