Session
The following views provide information about the current Oracle session:
- *$MYSTAT
Provides information about current session statistics. One row exists for every entry in *$STATNAME.
- *$PROCESS
Lists each process in the instance. You can join this view to *$SESSION to gain more information.
- *$SESS_IO
Provides up-to-date I/O information for each session in the database. Available after database is opened.
- *$SESSION
Lists each session in the instance.
- *$SESSION_CONNECT_INFO
Provides information about the network connection of the current session.
- *$SESSION_CURSOR_CACHE
Provides information about the current session’s cursor usage.
- *$SESSION_EVENT
Provides information about how much time each session spends waiting on each event specified in *$EVENT_NAME.
- *$SESSION_LONGOPS
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.
- *$SESSION_OBJECT_CACHE
Provides object cache statistics for the current session in the current instance.
- *$SESSION_WAIT
Lists the resources upon which each active session is waiting and how long each session has been waiting for each resource.
- *$SESSTAT
Provides information about each session’s session statistics. There is one row for each session for each statistic specified in *$STATNAME.