Dynamic v dollar (v$
) views have been historically used to perform session monitoring in character mode, this is useful when the DBA creates batch procedures or develops PLSQL programming to monitor the users activity.
The traditional views used to perform manual analysis and session analysis queries are:
V$SESSION:
This view lists information for each current session.V$SESSION_CONNECT_INFO:
This view displays information about network connections for the current session.V$SESSION_CURSOR_CACHE:
This view displays information on cursor usage for the current session.V$SESSION_EVENT:
This view lists information on waits for an event by a session. If you see a value of zero on theTIME_WAITED
andAVERAGE_WAIT
columns, this means that the platform does not support the fast timing. If this is the case then set theTIMED_STATISTICS
instance parameter to true.V$SESSION_LONGOPS:
This view provides information about tasks that last more than 6 seconds...