Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-06570

shared pool object does not exist, cannot be pinned/purged

Cause

The specified shared pool shared cursor could not be found, therefore it cannot be pinned/purged.


Action

Make sure that a correct shared cursor name is given. Names are a string of the form 'HHHHHHHH,SDDDDDDDDDD' where the H's are an 8 digit hex number from the 'address' column of v$sqlarea, and the D's are a 1 to 10 digit decimal number with an optional leading sign (from the 'hash_value' column) Remove the procedure from the calling stored procedure.