Re: Finding the DB State

hello,

    check for the table v$instance

krish wrote:

> Hi ,
>
> Is there any v$ table/view that tells me the state of the
> database - whether opened / closed / mounted ??
>
> Thanx.
>
> ------------------------------------------------------------------------
>
> T Krishnanand <tkrishna_at_baan.com>
> Junior DBA - Oracle
> Baan Info Systems India Pvt. Ltd.
>
> T Krishnanand
> Junior DBA - Oracle <tkrishna_at_baan.com>
> Baan Info Systems India Pvt. Ltd. HTML Mail
> 8-2-120/112 , Block A, Palace View Estate Work: +91-40-3600002
> Road No.2 , Banajara Hills Fax: +91-40-217366
> Hyderabad Home: +91-40-290903
> Andhra Pradesh Netscape Conference Address
> 500033 Hostname or IP Address
> India www.ils.baan.com
> Additional Information:
> Last Name Krishnanand
> First Name T
> Version 2.1
Received on Sun Mar 15 1998 - 00:00:00 CST