Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Show when the current user connected to the system (not available on all platforms)

SQL> SQL> select SID,TO_CHAR(SysDate - (Hsecs-S.Value)/(24*3600*100),'MM/DD/YYYY HH24 :MI:SS')  Connection_Time   2    from V$SESSTAT S, V$STATNAME N, V$TIMER   3   where N.Name = 'session connect time'   4     and N.Statistic# = S.Statistic#   5     and S.Value != 0;        SID  CONNECTION_TIME ----------  -------------------          1  03/20/2010 17:59:14 1 row selected. SQL> SQL>