Get Live Help
Shared pool latches control access to the shared pool memory map.
The primary cause of contention is excessive hard parsing. This can indicate the need to use bind variables or adjust the CURSOR_SHARING parameter.
To combat shared pool fragmentation: