Answers for "see session table oracle"

SQL
0

oracle current session details

SELECT sys_context('USERENV', 'SID') FROM DUAL;
Posted by: Guest on March-22-2021
0

oracle session statistics

SELECT sn.NAME, ss.VALUE
FROM V$SESSTAT ss,
     V$STATNAME sn,
     V$SESSION s
WHERE ss.STATISTIC# = sn.STATISTIC#
  AND s.SID = ss.SID
  AND s.AUDSID = sys_context('USERENV', 'SESSIONID');
Posted by: Guest on September-12-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language