Home » Infrastructure » Unix » ORA-00604 & ORA-04031 - pls help (tru64 unix)
ORA-00604 & ORA-04031 - pls help (tru64 unix) [message #97532] Wed, 10 July 2002 05:48 Go to next message
Messages: 55
Registered: July 2000
Tru64 unix
We run a C,Pro*c program that makes every second a connection to the oracle database,
read out a table and disconnects.
After a while (10 hours the last time) we've got these messages :

ORA-00604:error occured at recusive SQL level1
ORA-04031: unable to allocate 4200 bytes of shared memory

I've checked : each time we connect, we disconnect.

Re: ORA-00604 & ORA-04031 - pls help (tru64 unix) [message #97533 is a reply to message #97532] Fri, 12 July 2002 15:59 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Select * from v$session;

See how many connections you have - it sounds like a session leak to me. I've often seen that when an exception occurs that the session isn't closed by the programmer. You should be able to easily identify your program in v$session.

If you can't, try adding someting like this to your C.
dbms_application_info.set_client_info( 'my c program module ABC...' );

select * from v$session where client_info = 'my c program module ABC...';
Previous Topic: HELP: SQL*Plus and report formatting/scripting
Next Topic: Re: VMS to UNIX Migration (Oracle)
Goto Forum:

Current Time: Thu Sep 28 17:10:20 CDT 2023