Show when the current user connected to the system (not available on all platforms). : V_statname « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. V_statname

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>








Related examples in the same category

1.Prints the total UGA for your environment
2.Show when the current user was last active.