ORA-600 (504) (row cache objects) Error

The customer database encountered a ORA-600 (504) error where 5th of the error parameters were row cache objects.

Previously I encountered a related latch for a shared pool:

Error message:

Wed Apr 18 06:03:41 2012

Errors in file/data/Oracle/admin/orcl/udump/orcl_ora_000038.trc:

ORA-00600: Internal error code, parameter: [504], [0x4628BD7A0], [32], [4], [row cache objects], [10], [2], [0x000000000]

The database version is 9.2.0.6. According to the MOS document, the cause is that the V $ SQL _PLAN view is queried and the current session has an incompatible library cache latch.

The solution provided by Oracle is only to upgrade to 10.2.0.1. For versions earlier than 10.2, you can consider setting the implicit parameter _ cursor_plan_unparse_enabled to false to solve this problem.