fengbao

5 积分	1 好友	8 主题

发消息

[ORA-600/ORA-7445] session中的sql_id 查找不到对应的SQL语句

1^#

发表于 2013-10-31 12:02:30 | 查看: 4116| 回复: 4

本帖最后由 fengbao 于 2013-10-31 12:06 编辑

数据库环境：
   oracle 10.2.0.5  rac

现象：
STATUS EVENT                                     SQL_ID                   LOGON_TIME       SYSDATE
-------- ---------------------------- ------------- ----------- ----------- --------------
INACTIVE SQL*Net message from client bh9xcrqy224pm    2013-10-31 11:35:20 2013-10-31 11:54:37
INACTIVE SQL*Net message from client bh9xcrqy224pm    2013-10-31 11:31:51 2013-10-31 11:54:37
INACTIVE SQL*Net message from client bh9xcrqy224pm    2013-10-31 11:22:52 2013-10-31 11:54:37
INACTIVE SQL*Net message from client bh9xcrqy224pm    2013-10-31 11:22:46 2013-10-31 11:54:37
INACTIVE SQL*Net message from client bh9xcrqy224pm    2013-10-31 11:22:46 2013-10-31 11:54:37
INACTIVE SQL*Net message from client bh9xcrqy224pm    2013-10-31 11:21:03 2013-10-31 11:54:37
INACTIVE SQL*Net message from client bh9xcrqy224pm    2013-10-31 11:16:57 2013-10-31 11:54:37
INACTIVE SQL*Net message from client bh9xcrqy224pm    2013-10-31 11:16:23 2013-10-31 11:54:37
INACTIVE SQL*Net message from client bh9xcrqy224pm    2013-10-31 11:15:31 2013-10-31 11:54:37
INACTIVE SQL*Net message from client bh9xcrqy224pm    2013-10-31 11:09:46 2013-10-31 11:54:37
INACTIVE SQL*Net message from client bh9xcrqy224pm    2013-10-31 11:09:06 2013-10-31 11:54:37
INACTIVE SQL*Net message from client bh9xcrqy224pm    2013-10-31 11:09:05 2013-10-31 11:54:37
INACTIVE SQL*Net message from client bh9xcrqy224pm    2013-10-31 11:04:21 2013-10-31 11:54:37
INACTIVE SQL*Net message from client bh9xcrqy224pm    2013-10-31 11:04:21 2013-10-31 11:54:37
INACTIVE SQL*Net message from client bh9xcrqy224pm    2013-10-31 11:03:37 2013-10-31 11:54:37

  该SQL_ID对应的SQL，在v$sql v$sqlarea 以及dba_hist_sql相关的表，通过sql_id、sql_hash_value、plan_hash_value等均查看不到。
  且在v$open_cursor也查看不到。

请教一下，在什么样的情况才会产生这样的现象呢？

logon time即使=sysdate也看不到相应的SQL

分享0