Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> decipher statistic #13 from v$sesstat

decipher statistic #13 from v$sesstat

From: <johnvue_at_gte.net>
Date: Sun, 07 Jun 1998 21:25:23 GMT
Message-ID: <6lf0hq$bem$1@gte2.gte.net>


When looking at v$sesstat or v$mystat, STATISTIC# 13 is "session connect time".

If I do:

select * from v$mystat where statistic#=13;

       SID STATISTIC# VALUE
---------- ---------- ----------

         8 13 335028213

How do I get human readable information from this?

I know there is LOGON_TIME in V$SESSION but Oracle 7.0 and 7.1 don't have this field. Received on Sun Jun 07 1998 - 16:25:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US