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>