暂无图片
ORA-16957: SQL Analyze time limit interrupt
最近更新：2022-11-01 22:09:12

适用范围

Linux x86 64-bit下Oracle 12.1.0.2.0的RAC

问题概述

alert log中偶尔会出现ORA-16957:SQL Analyze time limit interrupt 最近一次的记录： image.png

问题原因

  1. 查看trace文件，内容如下：
*** 2022-10-03 22:12:09.255
*** SESSION ID:(2931.31445) 2022-10-03 22:12:09.255
*** CLIENT ID:() 2022-10-03 22:12:09.255
*** SERVICE NAME:(SYS$USERS) 2022-10-03 22:12:09.255
*** MODULE NAME:(DBMS_SCHEDULER) 2022-10-03 22:12:09.255
*** CLIENT DRIVER:() 2022-10-03 22:12:09.255
*** ACTION NAME:(ORA$AT_SQ_SQL_SW_1265) 2022-10-03 22:12:09.255
 
ORA-16957: SQL Analyze time limit interrupt
Dump of memory from 0x0000003DF95B9F70 to 0x0000003DF95BA3F8
3DF95B9F70 53202A2F 41204C51 796C616E 3228657A  [/* SQL Analyze(2]
3DF95B9F80 2C313339 2A202931 770A202F 20687469  [931,1) */ .with ]
3DF95B9F90 61207275 53282073 43454C45 2A2F2054  [ur as (SELECT /*]
3DF95B9FA0 74616D2B 61697265 657A696C 41454C20  [+materialize LEA]
3DF95B9FB0 474E4944 53224028 46244C45 37424235  [DING(@"SEL$F5BB7]
3DF95B9FC0 22314534 22552220 45532240 2232244C  [4E1" "U"@"SEL$2"]
3DF95B9FD0 22542220 45532240 2232244C 22452220  [ "T"@"SEL$2" "E"]
......