Re: SQL command to determine if DB is open

"Andy Weiss" <amw157_at_aol.com> wrote in message news:6b0f7239.0108080617.5e6e3a52_at_posting.google.com...
> > If I understand you correctly, how about using something like the
 v$instance
> > view (described next)
>
> I guess I should have been more specific. I need to do this from
> within a batch file. In other words, if the database is open, do
> these steps; if the database is not open, do these other steps.
>
> I don't think v$instance will do the trick for me. I need a statement
> that returns to me a boolean or an integer that tells whether the
> result of the statement was true or false.
>
> Andy

As usual posting a platform and a version is usually helping tremendously in getting responses.
Now I have to search for my crystall ball. In Unix a simple ps -ef | grep PMON would do

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Wed Aug 08 2001 - 11:31:41 CDT