Re: I need some helps ORA:4031.

From: Joseph Li <lijoecyn_at_netspace.net.au>
Date: 2000/07/06
Message-ID: <3964F19F.651EC8B0@netspace.net.au>#1/1

This is quite an old version of Oracle Server.

I agree with Connor's suggestion. More work needs to be done.

Test running the job immediately after instance startup ie. almost empty shared pool
except some sys packages might have already been pinned.

rgds
Joseph

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
Received on Thu Jul 06 2000 - 00:00:00 CDT