Oracle 8.1.7.0.0
Solaris 5.8
DBI 1.18
DBD 1.07
We run a script 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 :
DBI-connect(TEST) failed: 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.
Is it possible that after a disconnect the DBI::DBD doesn't give all the
resources back -> so there is a kind of cumulative error
Ann