Oracle Database Administration: The Essential Refe

SQL

These views provide information about the processing of all SQL statements in the instance:

V$OBJECT_DEPENDENCY

Lists all objects that a package, procedure, or cursor in the SGA is depending upon. This view can be joined to the V$SQL and V$SESSION views to obtain a list of all objects being referenced by a user.

V$OPEN_CURSOR

Lists all open cursors in the system.

V$SORT_SEGMENT

Provides information about all sort segments in tablespaces specified as TEMPORARY.

V$SORT_USAGE

Provides information about sort segments in all tablespaces.

V$SQL

Provides information about all SQL statements in the shared SQL area.

V$SQL_BIND_DATA

Provides information about the bind variables provided for each SQL statement.

V$SQL_BIND_METADATA

Provides metadata about all bind variables used in SQL statements.

V$SQL_CURSOR

Provides debugging information about every cursor in the shared SQL area.

V$SQL_SHARED_MEMORY

Provides information about how memory is allocated for every cursor in the shared SQL area.

V$SQLAREA

Provides information on all SQL statements in the shared SQL area.

V$SQLTEXT

Provides the text of all SQL statements in the shared SQL area. All newline and tab information is replaced by spaces.

V$SQLTEXT_WITH_NEWLINES

Provides the text of all SQL statements in the shared SQL area, but includes the original newline and tab characters.