[Solved] ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select

####
EXP-00008: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 3
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select t.ts#,t.file#,t.block...","KGLH0^1182baa5","kglHeapInitialize:temp")
. . exporting table           REPCAT$_AUDIT_COLUMN
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed

## Check the shared pole size
SELECT NAME, VALUE/(1024*1024) SHARED_POOL_SIZE_MB FROM V$PARAMETER WHERE NAME LIKE '%shared_pool%';

SELECT POOL,NAME, ROUND(BYTES/(1024*1024),2) FREE_MB
FROM V$SGASTAT WHERE POOL='shared pool'
AND NAME='free memory'
ORDER BY BYTES DESC;

select * from v$sgainfo


SELECT shared_pool_size_for_estimate "Size of Shared Pool in MB",
shared_pool_size_factor "Size Factor", estd_lc_time_saved "Time Saved in sec" FROM v$shared_pool_advice;

select COMPONENT,MIN_SIZE,MAX_SIZE, CURRENT_SIZE from  v$memory_dynamic_components;