Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: maintaining a connection
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;