9.23 V$SESSION_LONGOPS
V$SESSION_LONGOPS
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
orSQL_TRACE
parameters totrue
-
Gather statistics for your objects with 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.
Column | Datatype | Description |
---|---|---|
|
|
Identifier of the session processing the long-running operation. If multiple sessions are cooperating in the long-running operation, then |
|
|
Serial number of the session processing the long-running operation. If multiple sessions are cooperating in the long-running operation, then |
|
|
Brief description of the operation |
|
|
Object on which the operation is carried out |
|
|
Description of the target |
|
|
Units of work done so far for the operation specified in the |
|
|
Total units of work for the operation specified in the |
|
|
Units of measurement |
|
|
Starting time of the operation |
|
|
Time when statistics were last updated for the operation |
|
|
Timestamp specific to the operation |
|
|
Estimate (in seconds) of time remaining for the operation to complete |
|
|
Number of elapsed seconds from the start of the operations |
|
|
Context |
|
|
Statistics summary message |
|
|
User ID of the user performing the operation |
|
|
Used with the value of the |
|
|
Used with the value of the |
|
|
SQL identifier of the SQL statement associated with the long operation, if any |
|
|
SQL plan hash value; NULL if |
|
|
Time when the execution of the SQL started; NULL if |
|
|
SQL execution identifier (see |
|
|
SQL plan line ID corresponding to the long operation; NULL if the long operation is not associated with a line of the execution plan |
|
|
Plan operation name; NULL if |
|
|
Plan operation options; NULL if |
|
|
Session identifier of the parallel coordinator |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
-
Oracle Database PL/SQL Packages and Types Reference for more information about the
DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS
procedure -
Oracle Database PL/SQL Packages and Types Reference for more information about the
DBMS_STATS
package