home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1992 #26 / NN_1992_26.iso / spool / comp / database / oracle / 2173 < prev    next >
Encoding:
Internet Message Format  |  1992-11-11  |  1.4 KB
  1. Path: sparky!uunet!destroyer!gatech!ukma!seismo!jean
  2. From: jean@seismo.CSS.GOV (Jean Anderson)
  3. Newsgroups: comp.databases.oracle
  4. Subject: Yoo Hoo--are you still there?
  5. Summary: detecting dead processes
  6. Keywords: ping
  7. Message-ID: <51455@seismo.CSS.GOV>
  8. Date: 11 Nov 92 20:28:23 GMT
  9. Sender: usenet@seismo.CSS.GOV
  10. Followup-To: jean@esosun.css.gov
  11. Organization: SAIC Open Systems Division, San Diego, CA
  12. Lines: 25
  13. Nntp-Posting-Host: beno.css.gov
  14.  
  15. What's the cheapest way to tell from OCI if a frontend database connection 
  16. is still alive? I want to do something like this:
  17.  
  18.     if(db_dead()==TRUE)
  19.     {
  20.         -- do something reasonable, maybe re-establish connection
  21.     }
  22.  
  23. I'm looking for a cheap ping for db_dead(), maybe a "select 'x' from dual",
  24. although I'd like to avoid a select.
  25.  
  26. Is there a better way to check, maybe already a hook I don't know about?
  27.  
  28. thanks,
  29.  
  30.  -jean
  31.  
  32. +-----------------------------------------------------------------------+
  33. | Jean Anderson, DBA                       email:  jean@esosun.css.gov  |
  34. | SAIC Open Systems Division, MS A2-F                                   |
  35. | 10210 Campus Point Drive                 phone:  (619)458-2727        |
  36. | San Diego, CA  92121                       fax:  (619)458-4993        |
  37. +-----------------------------------------------------------------------+
  38. |            execute disclaimer(opinion => 'mine');                     |
  39. +-----------------------------------------------------------------------+
  40.