Get ORA-600: [504] [] [] [shared pool] in Alert.log File (Doc ID 281779.1)

Last updated on DECEMBER 03, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 9.2.0.3 to 9.2.0.8 [Release 9.2]
Oracle Server - Personal Edition - Version 9.2.0.3 to 9.2.0.8 [Release 9.2]
Oracle Server - Standard Edition - Version 9.2.0.3 to 9.2.0.8 [Release 9.2]
Information in this document applies to any platform.

Symptoms

The following error shows in the alert.log file:
ORA-600: [504] [0x380069508] [640], [7] [shared pool] [2] [0] [0x380069410]

Stack Trace:
kslgetl kghfre kghfrh kglfall kghfrx kghfrunp kghfnd kghalo kmnsbm nsballoc   

The error can occur during one of following circumstances:
- After executing 'alter system flush shared pool'.
- Under a heavy load.
- Running batch jobs.

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