Session Management - Oracle 10g/11g Data and Database Management Utilities - page 188

The report has seven main sections:
• The report header : A report summary that provides generic information.
• Top Events : The most outstanding events reported during the given period
of time.
• Load Profile: : This section reports which were the most active database
services, the most outstanding clients and the top SQL command types issued.
• Top SQL : This is self explanatory, the most meaningful SQL statements.
• Top Sessions : This shows the most active sessions, it shows the session
details ordered by the activity percentage, the reason why the event is
considered a top session, and other session specific details. This section also
includes a blocking sessions and a parallel query report section.
• Top Object / Files / Latches : This details which objects were used the most.
• Activity Over Time : This section summarizes the activity over the given
period of time.
Session monitoring, the traditional way
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 the TIME_WAITED and AVERAGE_WAIT
columns, this means that the platform does not support the fast timing. If this
is the case then set the TIMED_STATISTICS instance parameter to true.