ORA-00600  with Flashback Database enable
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.
ORA-00600  when using flashback database. There may also be addional ORA-4030 errors reported.
ORA-04030: out of process memory when trying to allocate 10485772 bytes (pga heap,LNS Buffer)
ORA-00600: internal error code, arguments: , , ,
ORA-03135: connection lost contact
- The trace file indicates freeable memory chunks labeled "krfr_init_read_" and "krfrbAllocate: "
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: "
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms