oracle 递归级别,ORA-00604: 递归 SQL 级别 ORA-00604: 递归 SQL 级别 2 出现错误

Dump file d:\oracle\product\10.2.0\bdump\oradb_cjq0_8188.trcTue Aug 20 00:05:25 2013ORACLE V10.2.0.1.0 - Production vsnsta=0vsnsql=14 vsnxtr=3Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

长耳朵狐狐

1238人浏览 · 2021-04-05 19:55:34

长耳朵狐狐 · 2021-04-05 19:55:34 发布

Dump file d:\oracle\product\10.2.0\bdump\oradb_cjq0_8188.trc

Tue Aug 20 00:05:25 2013

ORACLE V10.2.0.1.0 - Production vsnsta=0

vsnsql=14 vsnxtr=3

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

Windows Server 2003 Version V5.2 Service Pack 2

CPU : 16 - type 586, 2 Physical Cores

Process Affinity : 0x00000000

Memory (Avail/Total): Ph:5028M/8181M, Ph+PgF:7225M/10021M, VA:904M/2047M

Instance name: oradb

Redo thread mounted by this instance: 1

Oracle process number: 20

Windows thread id: 8188, image: ORACLE.EXE (CJQ0)

*** 2013-08-20 00:05:25.533

*** SERVICE NAME

SYS$BACKGROUND) 2013-08-20 00:03:17.104

*** SESSION ID

269.1) 2013-08-20 00:03:17.104

Waited for process J000 to initialize for 60 seconds

*** 2013-08-20 00:05:25.533

Dumping diagnostic information for J000:

OS tid = 3396

Memory (Avail/Total): Ph:5035M/8181M, Ph+PgF:7231M/10021M, VA:897M/2047M

CPU Load: 5%

------------------- Call Stack Trace ---------------------

calling location entry point arg #1 arg #2 arg #3 arg #4

------------------------------------------- ------------------------------------------- -------- -------- -------- --------

7C95845C 00000000 00000000 00000000 00000000 00000000

_sdpri+436 00000000 00000000 00000000 00000000 00000000

_ksdfini+418 00000000 0c6bdaec 0c6bd99c 00000018 031c165c

_ksdfmw+927 _ksdfini+0 004389ac 00000000 00000000 00000000

_ksdwrf+14 _ksdfmw+0 00000001 00000000 034a84d4 0c6bec98

__VInfreq__kkjrdp+218 _ksdwrf+0 034a84d4 00000262 00000000 00000000

_opirip+1163 _kkjrdp+0 00000000 00000000 00000000 00000000

_opidrv+857 _opirip+0 00000032 00000004 0c6bfec0 00000000

_sou2o+45 _opidrv+0 00000032 00000004 0c6bfec0 00000000

_opimai_real+227 _sou2o+0 0c6bfeb4 00000032 00000004 0c6bfec0

_opimai+92 _opimai_real+0 00000003 0c6bfeec 00000000 00000000

_BackgroundThreadStart@4+422 _opimai+0 00000000 00000000 00000000 00000000

7C82482C 00000000 00000000 00000000 00000000 00000000

---------------- End of Call Stack Trace -----------------

Call stack acquisition performance stats:

setup time (lock acquis., memory alloc.): 0 ms

frame get time (time the target proc was suspended): 0 ms

symbol translation time: 297 ms

total time: 297 ms

*** 2013-08-20 00:05:25.846

Process J000 is dead (pid=3396, state=5):

*** 2013-08-20 16:35:34.374

Process J000 is dead (pid=4960, state=3):