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

0 vote189 views1 answer
How to start my sql server on mac
SQL
0 vote285 views2 answers
Search stored procedures by name
SQL
0 vote221 views1 answer
Sql query use select name inside where clause
SQL
0 vote223 views1 answer
Can you write relational algebra into sql queries
SQL
5 votes336 views2 answers
Mysql date greater than 30 days
SQL
0 vote198 views1 answer
Sql delete from with relation
SQL
0 vote196 views1 answer
Mysql count number of occurrences in a column
SQL
-1 vote286 views3 answers
PS5
SQL
0 vote198 views1 answer
Sql server set complex constraints
SQL
0 vote208 views1 answer
Postgresql isnull with max
SQL