Log-In to post
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.
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