Re: I need some helps ORA:4031.

From: <ajung_at_suxers.de>
Date: 2000/07/04
Message-ID: <7798.3961934c.c9f09@yetix.sz-sb.de>#1/1

Miro Kundacina <miro_at_sb-soft.co.yu> wrote: 2qy
2qyHello,
2qy
2qyI need some helps.
2qyError description:
2qyError ODBC/18 Error during execute SQL (SQLCODE=-1) (S1000 - 4031 - 2qy[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-04031: unable to allocate 740 2qybytes of shared memory ("unknown object","sga heap","library cache").) 2qy
2qy- Oracle7 Server Release 7.3.2.3.0
2qy- RS/6000 J40 (Aix 4.1 ) RAM 512 Mb

Looks like you need to provide more shared memory for Oracle. Usually this is a parameters that is set for the complete machine. So ask your system administrator to get more memory.

Andreas Received on Tue Jul 04 2000 - 00:00:00 CDT