ORA-600 [729] on ktspsrchche if there was an ORA-4031 ealier (Doc ID 469678.1)

Last updated on JULY 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.

Symptoms


User process or a SHARED Server can report a memory leak through ORA-00600: internal error code, arguments: [729] on ktspsrchche if the session received an ORA-04031 earlier.


*** SESSION ID:(70.40954) 2007-10-17 14:45:13.521
*** 2007-10-17 14:45:13.521
=================================
Begin 4031 Diagnostic Information
=================================

The following information assists Oracle in diagnosing
causes of ORA-4031 errors. This trace may be disabled
by setting the init.ora _4031_dump_bitvec = 0

*** 2007-10-17 15:03:58.676
*** ACTION NAME:() 2007-10-17 15:03:58.676
*** MODULE NAME:() 2007-10-17 15:03:58.676
*** SERVICE NAME:(NAVP.WORLD) 2007-10-17 15:03:58.676
*** SESSION ID:(58.4944) 2007-10-17 15:03:58.676
******** ERROR: UGA memory leak detected 208 ********

EXTENT 9 addr=8F2BA054
Chunk 8f2ba05c sz= 512 free " "
Chunk 8f2ba25c sz= 72 freeable "ktspsrchche "
Dump of memory from 0x8F2BA25C to 0x8F2BA2A4
8F2BA250 00000049 [I...]
8F2BA260 8F2BA05C 0397E284 00000000 00000FE4 [\.+.............]
8F2BA270 000007F1 00000400 00000000 00000000 [................]
8F2BA280 00000000 00000000 00000000 00000000 [................]
8F2BA290 00000000 00000000 00000000 000BE6AB [................]
8F2BA2A0 0000002F [/...]

Note the leak in ktspsrchche: L2', which is the highest leak:

EXTENT 0 addr=70000008ef78488
Chunk 70000008ef78498 sz= 32704 freeable "ktspsrchche: L2"
Dump of memory from 0x070000008EF78498 to 0x070000008EF80458
70000008EF78490 10B38F00 00007FC1 [........]
70000008EF784A0 00000000 00000000 00000001 047337FC [.............s7.]
70000008EF784B0 00000000 00000000 00000000 00000000 [................]

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms