Oracle Server Manager User's Guide

The Table Access Monitor

The Table Access Monitor lists database objects that are being accessed and the sessions that are accessing them.

The following figure illustrates the left-most columns of the Table Access Monitor.

Figure 11 - 15. Table Access Monitor

The Table Access Monitor is described below:

SID Identifier for the session currently accessing the object.
Schema Name Owner of the object being accessed.
Table Name Name of the object being accessed.

Filters

The following filters are available in the Table Access Monitor:

Min SID Minimum session ID. Monitor displays sessions with ID numbers greater than or equal to Min SID.
Max SID Maximum session ID. Monitor displays sessions with ID number less than or equal to Max SID.
Schema Filter for owner name. Monitor displays information for objects whose owners match the Schema filter.
Table Filter for object names. Monitor displays information for objects whose names match the Table filter.

SQL Worksheet Equivalent

To start the Table Access Monitor from a SQL Worksheet, you can use the following Server Manager commands:

	MONITOR TABLEACCESS

	MONITOR TABLE

Required Views

To use the Table Access Monitor, you must have access to:

V$ACCESS

Interpreting Table Access Statistics

Use the Session Monitor to look up the user associated with a particular SID listed in the Table Access Monitor.

SID	Identifier for the session currently accessing the object.
Schema Name	Owner of the object being accessed.
Table Name	Name of the object being accessed.

Min SID	Minimum session ID. Monitor displays sessions with ID numbers greater than or equal to Min SID.
Max SID	Maximum session ID. Monitor displays sessions with ID number less than or equal to Max SID.
Schema	Filter for owner name. Monitor displays information for objects whose owners match the Schema filter.
Table	Filter for object names. Monitor displays information for objects whose names match the Table filter.