V$SESSION_LONGOPS bug
概念了解：
此View显示用户操作时间超过6 seconds 的执行状态。
这些操作包括 备份恢复功能，统计信息收集，执行查询和其他一些oracle 操作。
需要监视查询的执行，数据库必须使用 CBO 并且设置 Parameters
timed_statistics=true or sql_trace=true
使用analyze 语句或dbms_stats package 收集对象的统计信息。
bug 显现
| SID | SERIAL# | TARGET_DESC | SOFAR | TOTALWORK | START_TIME | LAST_UPDATE_TIME | USERNAME | SQL_ADDRESS |
| 29 | 183 | 256 | 256 | 2006-06-05 12:55:49 | BQY | ? 2358537492 | ||
| 29 | 5912 | x虁 | 7984 | 7984 | 2054-10-25 03:14:09 | 2006-06-06 16:38:03 | BQY | ? 2615825342 |
| 31 | 391 | 137438953504 | 137438953504 | 1988-01-01 00:00:32 | 2006-06-06 08:19:17 | BQY | ? 3290242800 | |
| 31 | 391 | p | 9223372041150663488 | 9223372041150663488 | 2054-10-25 03:14:09 | 2006-06-06 08:19:18 | BQY | ? 3290242800 |
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.
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.
红色部分现在2054年，但在Schema 描述的是 The starting time of operation. 显然结果和描述是不相符的。
[@more@]Version=8.1.7.4