Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Dynamic Performance (V$) Views, 161 of 211
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:
TIMED_STATISTICS
or SQL_TRACE
parameter to TRUE
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:
Oracle9i Supplied PL/SQL Packages and Types Reference for more information on |
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|