ORA-00600 [723] with Flashback Database enable (Doc ID 605185.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4
This problem can occur on any platform.

Symptoms

ALERT LOG 
---------
ORA-04030: out of process memory when trying to allocate 10485772 bytes (pga heap,LNS Buffer)
...
ORA-00600: internal error code, arguments: [723], [29423564], [29423564],
ORA-03135: connection lost contact
HEAP DUMP heap name="pga heap" desc=5BBE34D8 
extent sz=0x206c alt=92 het=32767 rec=0 flg=3 opc=3
parent=00000000 owner=00000000 nex=00000000 xsz=0x0
EXTENT 0 addr=78030008 
...
Chunk 780300d0 sz= 660 freeable "krfr_init_read_"
...
Chunk 7803fdf4 sz= 2097676 freeable "krfrbAllocate: "


Changes

Issue may occur when database is enabled as flashback database. Flashback database can be verified by executing:

SQL> select FLASHBACK_ON from v$database;

If the query returns FLASHBACK_ON = 'YES' then flashback database is active.

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