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_WAITEDandAVERAGE_WAITcolumns, this means that the platform does not support the fast timing. If this is the case then set theTIMED_STATISTICSinstance parameter to true.V$SESSION_LONGOPS:This view provides information about tasks that last more than 6 seconds...