Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

(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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://111200]
help
Chatterbox?
[planetscape]: sleep well, Corion
[stonecolddevin]: erix seems pretty good, i listened to "So Many Roads" and it was nice. Not everyone's cup of tea but this guy can absolutely shred, he and the guy from Mastodon are definitely up there: https://www. youtube.com/watch? v=VzhMkSN9dQc
[erix]: ha, good stuff - loud and fast...
[stonecolddevin]: here's some Mastodon for when you have 13 minutes to have your mind blown: https://www. youtube.com/watch? v=4pvfQtUhtNE
[karlgoethebier]: goes to Brownsville one more time..

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (9)
As of 2017-06-22 21:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many monitors do you use while coding?















    Results (531 votes). Check out past polls.