Error on rac : Error 569 occured while spilling buffered messages
ORA-600 ,  Followed by ORA-569 in One Instance of a RAC Database [ID 603650.1]
In one instance of a RAC database the following errors are reported:
ORA-00600: internal error code, arguments: , , [0x3BE751F30], , , , , 
ORA-00569: Failed to acquire global enqueue.
In another instance, just before the above errors shared pool problems are reported, e.g.:
WARNING: ran out of shared pool for GES enqueue object.
This may be followed by ORA-4031 shared pool related errors.
This issue is discussed in unpublished Bug:6928203 "AIX10204-080316: ORA-600: ARGUMENTS: , , [0X70000004AAE1CF0]" which was closed as *not* a bug.
Here are the conclusions from this bug:
- ORA-600 ,  and ORA-569 mean the same thing.
- The ORA-600 / ORA-569 errors are a consequence of shared pool issue in the other instance (ORA-4031 errors).
Solving the ORA-4031 error in the instance reporting it will solve the ORA-600 / ORA-569 in the other instance.
The first step in solving ORA-4031 errors will be to increase SGA_TARGET if Automatic Shared Memory Management (ASMM) is used or to increase SHARED_POOL_SIZE if ASMM is not used.
Join Factorization - This item is, by a roundabout route, a follow-up to yesterday’s note on a critical difference in cardinality estimates that appeared if you used the coales...
Acum 3 zile