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');

Similar codes

6 votes196 views6 answers
Count mysql
SQL
0 vote219 views1 answer
How to inner join 4 tables in sql
SQL
25 votes203 views3 answers
How to use a database to see tables mysql
SQL
0 vote216 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote193 views2 answers
How to update date in oracle
SQL
0 vote228 views1 answer
Alternative for LIMIT sql
SQL
0 vote184 views1 answer
Postgres select except
SQL
1 vote218 views1 answer
Write a query to create an empty table from an existing table?
SQL
0 vote200 views1 answer
Show mysql account privilleges
SQL
2 votes163 views2 answers
Mysql get last character of string
SQL