Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

(jptxs) Re: DBI - cursors left open in Oracle - for now...

by jptxs (Curate)
on Sep 08, 2001 at 23:02 UTC ( #111200=note: print w/ replies, xml ) Need Help??

in reply to DBI - cursors left open in Oracle

I've never seen this particular behavior, but I have seen Oracle do a number of incredibly odd things on Linux. Oracle has told me that the client on Linux is the root of the cause in many cases. What I had done in one case where mystery sessions were being spawned was to simply write a script to query the sys views (v$sessions in my case, but v$open_cursors in yours) for the offending conditions periodically through cron and to kill off the asociated processes. It will depend on your exact configuration and session management style, but this may work for you for now as well. At least until you get through this.

we eventually had to run Oracle on Sun to get the stability we needed.

We speak the way we breathe. --Fugazi

Comment on (jptxs) Re: DBI - cursors left open in Oracle - for now...

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://111200]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (3)
As of 2015-11-27 12:43 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (728 votes), past polls