Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> decipher statistic #13 from v$sesstat
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