ORA-04031: unable to allocate 57208 bytes of shared memory ("shared pool","unknown object","sga heap
I am facing ora-04031 shared memory error in rman backup log. i understand that is this because of shared pool is out of memory or fragmentation. and we have no
way to adjust the SGA size in production DR due to enterprise lockdown. i want to know whether the backup is good one or failed?
please advice how to check SGA current usage and what action i should take to fix this error.
channel t1: backup set complete, elapsed time: 00:03:56
released channel: t1
released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1 channel at 03/03/2011 22:49:12