Board index » delphi » Help with error ORA-04031 unable to allocate 740 bytes of shared memory

Lourdes Leticia Cahuich Campos

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Help with error ORA-04031 unable to allocate 740 bytes of shared memory

Im working with Oracle v7 and while is executing a large query, in some
point, sometimes shows the error:

"EDBEngineError with message 'key violation. [Oracle][ODBC Oracle
Driver]
[Oracle OCI] ORA-04031: unable to allocate 740 bytes of shared memory
("unknown object","sga General SQL error. hesp", "librerycache")!
Process stoped"

what can i do to correct this?

Thanks

 
Russell L. Smit

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Help with error ORA-04031 unable to allocate 740 bytes of shared memory


Have you tried increasing the value of SHARED_POOL_SIZE in the
initialization file for your instance?

V/R
Russell L. Smith

Lourdes Leticia Cahuich Campos wrote in message
<365ADCD0.A6AC...@campus.ccm.itesm.mx>...

Quote
>"EDBEngineError with message 'key violation. [Oracle][ODBC Oracle
>Driver]
>[Oracle OCI] ORA-04031: unable to allocate 740 bytes of shared memory
>("unknown object","sga General SQL error. hesp", "librerycache")!
>Process stoped"

Lourdes Leticia Cahuich Campo

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Help with error ORA-04031 unable to allocate 740 bytes of shared memory


No, how can i do that?
Quote
"Russell L. Smith" wrote:

> Have you tried increasing the value of SHARED_POOL_SIZE in the
> initialization file for your instance?

> V/R
> Russell L. Smith

> Lourdes Leticia Cahuich Campos wrote in message
> <365ADCD0.A6AC...@campus.ccm.itesm.mx>...
> >"EDBEngineError with message 'key violation. [Oracle][ODBC Oracle
> >Driver]
> >[Oracle OCI] ORA-04031: unable to allocate 740 bytes of shared memory
> >("unknown object","sga General SQL error. hesp", "librerycache")!
> >Process stoped"

Russell L. Smit

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Help with error ORA-04031 unable to allocate 740 bytes of shared memory


Ask your DBA to do it.  If you are "winging" it, you need to read about your
initialization file, which is named initorcl.ini by default but usually
renamed to correspond with the name of your database instance.

V/R
Russell L. Smith

Lourdes Leticia Cahuich Campos wrote in message
<365B551D.CDD5C...@campus.ccm.itesm.mx>...

Quote
>No, how can i do that?

Other Threads

1. ORA-01019: Unable to allocate memory in the user side

2. a pointer to an allocated byte memory area

3. Unable to allocate sufficient memory (SQL Links 2.52)

4. MSSQL 6.0 and Unable to allocate sufficient memory.

5. MSSQL and Unable to allocate sufficient memory !!!

6. ERROR: ORA-12203: TNS:unable to connect to destination

7. Oracle Errors ORA-03113 and ORA-01041

8. General SQL error: Memory Request for 2078 bytes...

9. Help - reading file of byte into memory?

10. Help - reading file of byte into memory?