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.

紅色部分現在2054年，但在Schema 描述的是 The starting time of operation. 顯然結果和描述是不相符的。

[@more@]

Version=8.1.7.4

V$SESSION_LONGOPS bug

相關文章

V$SESSION_LONGOPS　bug