V$SESSION_LONGOPS bug 【Blog 搬家】

myhuaer發表於2010-05-05

V$SESSION_LONGOPS bug

2006 年 06 月 07 日, 星期三

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. 顯然結果和描述是不相符的。

Version=8.1.7.4

myhuaer 發表於:2006.06.07 11:26 ::分類: ( Oracle Infomation ) ::閱讀:(353次)

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/34596/viewspace-661947/,如需轉載,請註明出處,否則將追究法律責任。

相關文章