Re: I need some helps ORA:4031.

From: Davide Bianchi <info_at_soft-land.org>
Date: 2000/07/04
Message-ID: <39619767.7546681@news.cis.dfn.de>#1/1

Probably you have to tune the Oracle Instances, increasing the shared memory used by Oracle itself. Check the init.ora file used by Oracle for the Instance.

Davide

On Tue, 4 Jul 2000 08:15:14 +0200, "Miro Kundacina" <miro_at_sb-soft.co.yu> 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 Tue Jul 04 2000 - 00:00:00 CDT