Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: User Connections
SET ECHO off
REM NAME: TFSCNTIM.SQL
REM USAGE:"@path/tfscntim"
REM --------------------------------------------------------------------
REM --------------------------------------------------------------------
REM --------------------------------------------------------------------
REM --------------------------------------------------------------------
REM ---------- ------------------------------ -------------------- REM 1 21-mar-97 09:17:39 REM 2 21-mar-97 09:17:39 REM 3 21-mar-97 09:17:39 REM 4 21-mar-97 09:17:39 REM 5 21-mar-97 09:17:39 REM 6 SYSTEM 02-aug-96 10:31:33 REM 7 SYSTEM 02-aug-96 12:34:13 REM 15 SYS 21-mar-97 09:17:39REM
REM --------------------------------------------------------------------
REM --------------------------------------------------------------------
column cnt format a20
select s.sid, s.username,
to_char((sysdate-(hsecs - value )/(100*60*60*24)),'dd-mon-yy hh:mi:ss')
cnt
from v$sesstat sess, v$session s, v$timer where statistic# = 13
and s.sid = sess.sid
/
SID USERNAME CNT
---------- ------------------------------ --------------------
1 21-mar-97 09:17:39 2 21-mar-97 09:17:39 3 21-mar-97 09:17:39 4 21-mar-97 09:17:39 5 21-mar-97 09:17:39 6 SYSTEM 02-aug-96 10:31:33 7 SYSTEM 02-aug-96 12:34:13 15 SYS 21-mar-97 09:17:39
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Feb 16 2000 - 00:00:00 CST
![]() |
![]() |