Oracle-v$session_longops-视图说明.docVIP

Oracle-v$session_longops-视图说明 Oracle v$session_longops 视图说明Oracle v$session_longops 视图说明 一. 官网说明 1.1 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: （1）Set the TIMED_STATISTICS or SQL_TRACE parameters to true （2）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. Column Datatype Description SID NUMBER Identifier of the session processing the long-running operation. If multiple sessions are cooperating in the long-running operation, then SID corresponds to the main or master session. SERIAL# NUMBER Serial number of the session processing the long-running operation. If multiple sessions are cooperating in the long-running operation, then SERIAL# corresponds to the main or master session. SERIAL# is used to uniquely identify a sessions objects. Guarantees that session-level commands are applied to the correct session objects if the session ends and another session begins with the same session ID. OPNAME VARCHAR2(64) Brief description of the operation TARGET VARCHAR2(64) Object on which the operation is carried out TARGET_DESC VARCHAR2(32) Description of the target SOFAR NUMBER Units of work done so far TOTALWORK NUMBER Total units of work UNITS VARCHAR2(32) Units of measurement START_TIME DATE Starting time of the operation LAST_UPDATE_TIME DATE Time when statistics were last updated for the operation TIMESTAMP DATE Timestamp specific to the operation TIME_REMAINING NUMBER Estimate (in seconds) of time remaining