The V$MYSTAT view contains statistics on the current session. The contents are intialized when you establish a connection and cleared when the connection is closed.

Column Datatype Description
SID NUMBER ID of the current session.
STATISTIC# NUMBER Number of the statistic.
VALUE NUMBER Value of the statistic.

The statistic# column can be joined with V$statname to get the description of the statistics.

The following query can be used to get the details of the current statistics.

SELECT ms.sid, sn.name,ms.value
  FROM V$MYSTAT ms, V$STATNAME sn
 WHERE ms.STATISITIC#=sn.STATISTIC#