Dynamic Performance (V$) Views, 140 of 179

V$SESSION_LONGOPS

This view displays the status of various operations that run for longer than 6 seconds (in absolute time). These operations currently include many backup and recovery functions, statistics gathering, and query execution, and more operations are added for every Oracle release.

To monitor query execution progress, you must be using the cost-based optimizer and you must:

Set the TIMED_STATISTICS or SQL_TRACE parameter to TRUE and
Gather statistics for your objects with the ANALYZE statement or the DBMS_STATS package.

You can add information to this view about application-specific long-running operations by using the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure.

See Also:
Oracle8i Supplied PL/SQL Packages Reference for more information on DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS.

Column Datatype Description

SID

NUMBER

Session identifier

SERIAL#

NUMBER

Session serial number

OPNAME

VARCHAR2(64)

Brief description of the operation

TARGET

VARCHAR2(64)

The object on which the operation is carried out

TARGET_DESC

VARCHAR2(32)

Description of the target

SOFAR

NUMBER

The units of work done so far

TOTALWORK

NUMBER

The total units of work

UNITS

VARCHAR2(32)

The units of measurement

START_TIME

DATE

The starting time of operation

LAST_UPDATE_TIME

DATE

Time when statistics last updated

TIME_REMAINING

NUMBER

Estimate (in seconds) of time remaining for the operation to complete.

ELAPSED_SECONDS

NUMBER

The number of elapsed seconds from the start of operations

CONTEXT

NUMBER

Context

MESSAGE

VARCHAR2(512)

Statistics summary message

USERNAME

VARCHAR2(30)

User ID of the user performing the operation.

SQL_ADDRESS

RAW(4)

Used with the value of the SQL_HASH_VALUE column to identify the SQL statement associated with the operation.

SQL_HASH_VALUE

NUMER

Used with the value of the SQL_ADDRESS column to identify the SQL statement associated with the operation.

QCSID

NUMBER

Session identifier of the parallel coordinator.

Column	Datatype	Description
`SID`	`NUMBER`	Session identifier
`SERIAL#`	`NUMBER`	Session serial number
`OPNAME`	`VARCHAR2(64)`	Brief description of the operation
`TARGET`	`VARCHAR2(64)`	The object on which the operation is carried out
`TARGET_DESC`	`VARCHAR2(32)`	Description of the target
`SOFAR`	`NUMBER`	The units of work done so far
`TOTALWORK`	`NUMBER`	The total units of work
`UNITS`	`VARCHAR2(32)`	The units of measurement
`START_TIME`	`DATE`	The starting time of operation
`LAST_UPDATE_TIME`	`DATE`	Time when statistics last updated
`TIME_REMAINING`	`NUMBER`	Estimate (in seconds) of time remaining for the operation to complete.
`ELAPSED_SECONDS`	`NUMBER`	The number of elapsed seconds from the start of operations
`CONTEXT`	`NUMBER`	Context
`MESSAGE`	`VARCHAR2(512)`	Statistics summary message
`USERNAME`	`VARCHAR2(30)`	User ID of the user performing the operation.
`SQL_ADDRESS`	`RAW(4)`	Used with the value of the SQL_HASH_VALUE column to identify the SQL statement associated with the operation.
`SQL_HASH_VALUE`	`NUMER`	Used with the value of the SQL_ADDRESS column to identify the SQL statement associated with the operation.
`QCSID`	`NUMBER`	Session identifier of the parallel coordinator.