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

2 votes177 views2 answers
Select multiple tables mysql
SQL
0 vote184 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote200 views1 answer
Renommer base sql
SQL
0 vote207 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
7 votes176 views6 answers
Nth highest salary in sql
SQL
2 votes190 views1 answer
Mysql id of inserted row
SQL
0 vote201 views1 answer
Postgresql port 5432 not open
SQL
0 vote178 views1 answer
Can't connect to postgresql mac os
SQL
0 vote201 views1 answer
Check if mysql db is used
SQL
17 votes177 views4 answers
Show tables sql server
SQL