Re: Unique Error comes during backup

Holger,

Thanks,

Could you please let me know where I find the note on METALINK, for getting the reasons of ora-04031 error?
I have a Metalink support.

Kind regards

Bill

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 - 12:54:07 CST