Tag: tag

Oracle shared pool memory fragmentation causing ORA-04031 error diagnosed using V$SGASTAT and V$SHARED_POOL_RESERVED on Oracle production database

ORA-04031: Shared Pool Exhaustion — Root Cause and Fix

Posted on by sanjeeva

In the life of an Oracle Database Expert, It usually early morning when the monitoring alert fired. Applications throwing ORA-04031. Developers calling. The on-call DBA logged in to find the shared pool exhausted — Oracle unable to allocate a single new object in memory. No new SQL could parse. No new PL/SQL could execute. The Read more about ORA-04031: Shared Pool Exhaustion — Root Cause and Fix[…]