| ORA-00604 & ORA-04031 - pls help (tru64 unix) [message #97532] |
Wed, 10 July 2002 05:48  |
Pradeep
Messages: 55
Registered: July 2000
|
Member |
|
|
Oracle 8.1.7.0.0
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.
pradeep
|
|
|
|
| Re: ORA-00604 & ORA-04031 - pls help (tru64 unix) [message #97533 is a reply to message #97532] |
Fri, 12 July 2002 15:59  |
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...';
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
