Re: I need some helps ORA:4031.

Miro Kundacina wrote:
>
> Hello,
>
> I need some helps.
> Error description:
> Error ODBC/18 Error during execute SQL (SQLCODE=-1) (S1000 - 4031 -
> [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-04031: unable to allocate 740
> bytes of shared memory ("unknown object","sga heap","library cache").)
>
> - Oracle7 Server Release 7.3.2.3.0
> - RS/6000 J40 (Aix 4.1 ) RAM 512 Mb
>
> The error occurs only in working with two tables (PAYMENTS, CARD), yet more
> complexed jobs are performed in other tables where the error doesn't occur.
>
> Thanks
>
> Miro Kundacina

Your shared pool is probably fragmented - typically caused by it either being too small, or poorly used, or both.

Whilst increasing it can fix the current problem, it rarely is a total cure. Time to start reading up on pinning commonly used objects.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse