In Oracle how to check current sessions and processes:
set pages 10000 line 200col username format a15col machine format a15col logon_time format a20col osuser format a10SELECT NVL(s.username, '(oracle)') AS username,s.osuser,s.sid,s.serial#,p.spid,s.lockwait,s.status,s.module,s.machine,s.program,TO_CHAR(s.logon_Time,'DD-MON-YYYY HH24:MI:SS') AS logon_time,s.LAST_CALL_ETFROM v$session s,v$process pWHERE s.paddr = p.addrAND s.username is not nullORDER BY s.LAST_CALL_ET, s.logon_Time, s.username, s.osuser;
No comments:
Post a Comment