Oracle Server Manager User's Guide

The SQL Area Monitor

The SQL Area Monitor displays information about shared cursors in the library cache. Each shared cursor contains information used to execute its SQL statement or PL/SQL block. Each row in the monitor shows statistics for one shared cursor.

The following figure illustrates the left-most columns of the SQL Area Monitor.

Figure 11 - 12. SQL Area Monitor

The SQL Area Monitor is described below:

SQL Statement Text Text of the cursor's SQL statement or the PL/SQL anonymous code.
Version Count Number of different versions of the cursor
The same text might be used by different users, each on their own version of an object. For example, if users SCOTT and BLAKE own EMP tables and execute the statement SELECT * FROM emp, they each have a different version of the cursor.
Sharable Memory Amount of memory in bytes that can be shared between users.
Memory/User Persistent For each user, the amount of memory in bytes that persists for the life of the cursor. Persistent memory is retained between executions of the statement.
Memory/User Runtime For each user, the amount of memory in bytes that is needed only during execution. Runtime memory exists only while the statement is being executed.

Filters

The following filter is available in the SQL Area Monitor:

Statement Filter for the statement text. Monitor displays information for cursors whose text matches the Statement filter.

SQL Worksheet Equivalent

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

	MONITOR SQLAREA

	MONITOR SQL

Required Views

To use the SQL Area Monitor, you must have access to:

V$SQLAREA

SQL Statement Text	Text of the cursor's SQL statement or the PL/SQL anonymous code.
Version Count	Number of different versions of the cursor
	The same text might be used by different users, each on their own version of an object. For example, if users SCOTT and BLAKE own EMP tables and execute the statement `SELECT * FROM emp`, they each have a different version of the cursor.
Sharable Memory	Amount of memory in bytes that can be shared between users.
Memory/User Persistent	For each user, the amount of memory in bytes that persists for the life of the cursor. Persistent memory is retained between executions of the statement.
Memory/User Runtime	For each user, the amount of memory in bytes that is needed only during execution. Runtime memory exists only while the statement is being executed.