ITPub博客

首页 > 应用开发 > IT综合 > V$SESSION_LONGOPS bug

V$SESSION_LONGOPS bug

原创 IT综合 作者:myhuaer 时间:2006-06-07 11:26:16 0 删除 编辑
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
291832562562006-06-05 12:55:49 BQY ? 2358537492
295912x 798479842054-10-25 03:14:09 2006-06-06 16:38:03 BQY ? 2615825342
313911374389535041374389535041988-01-01 00:00:32 2006-06-06 08:19:17 BQY ? 3290242800
31391
p
922337204115066348892233720411506634882054-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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/34596/viewspace-840999/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2016-09-11

  • 博文量
    211
  • 访问量
    634696