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


Reply via email to