Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: maintaining a connection

Re: maintaining a connection

From: Kenneth Koenraadt <kennethkoenraadt_at_>
Date: Thu, 17 Jan 2002 16:44:58 GMT
Message-ID: <3c46fe61.985744@news.mobilixnet.dk>


On Thu, 17 Jan 2002 13:03:01 GMT, willjamu_at_mindspring.com (James Williams) wrote:

>I am about to write a Proc program that will remain active pretty
>much for the life of the instance.
>
>What would one recommend as the best way to verify a good connection
>is available from time to time?
>
>

The following query should do the trick:

SELECT case when status = 'OPEN' then "Connection OK" else "No Connection Available" end as result
FROM V$INSTANCE;



Regards,
Kenneth Koenraadt
Systems Consultant
Oracle Certified Professional - DBA
kennethkoenraadt@<no-spam>hotmail.com Received on Thu Jan 17 2002 - 10:44:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US