Re: Unique Error comes during backup

Yep, I agree. It looks like your shared pool may be sized too small.

Mark Simmons
Sr. Oracle DBA
Sabre-Holdings, Southlake, TX

Holger Baer <holger.baer_at_science-computing.de> wrote in message news:<c2kp50$7rm$1_at_news.BelWue.DE>...
> BSena wrote:
> > Hi
> >
>
> <snip>
>
> >
> > ORA-12012RA-06508: PL/SQL: could not find program unit being called:
> > error on auto execute of job 9
> >
> > ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
> > pool","DECLARE job BINARY_INTEGER :...","PL/SQL MPCODE","BAMIMA: Bam
> > Buffer")
> >
> >
>
> It would be nice to know the version of Oracle but anyway...
> Seems like there are two errors worth investigating:
>
> ORA-12571 and ORA-04031
>
> Check Metalink, there is a note on how to detect and correct the reason
> for ORA-04031, which means basically that either your shared pool is plain
> to small, or your application is not using bind variables thus trashing
> the shared pool.
>
> Most likely if you solve the ORA-04031, the ORA-12571 will go away.
>
> HTH
>
> Holger
Received on Tue Mar 09 2004 - 13:42:57 CST