These views provide information about the current Oracle session:
Provides information about current session statistics. There is one row for every entry in V$STATNAME.
Lists each process in the instance. You can join this table to V$SESSION to gain more information.
Provides up-to-date I/O information for each session in the database.
Lists each session in the instance.
Provides information about the network connection of the current session.
Provides information about the current session’s cursor usage.
Provides information about how much time each session spends waiting on each event specified in V$EVENT_NAME.
Provides information about the status of long-running operations for sessions. Details the number of work units already accomplished and the expected amount of work required to complete the operation.
Provides object cache statistics for the current session in the current instance.
Lists the resources upon which each active session is waiting, and how long each session has been waiting for each resource.
Provides information about each session’s session statistics. There is one row for each session for each statistic specified in V$STATNAME.