Re: SQL command to determine if DB is open

From: Lowell Paden <paden_lv_at_nospam.yahoo.com>
Date: Wed, 8 Aug 2001 13:31:10 -0400
Message-ID: <iCec7.2$84.62@dit4.state.va.us>

If the database is down, you can't even logon. Any successful query will indicate that the database is up, even select * from dual.

"Andy Weiss" <amw157_at_aol.com> wrote in message news:6b0f7239.0108070910.40766f3f_at_posting.google.com...
> I need a quick command that I can execute in SQL Plus to determine if
> a database is open or not. Been wading through Oracle's documentation
> hopelessly for hours.
>
> Any suggestions?
> Andy
Received on Wed Aug 08 2001 - 12:31:10 CDT