Home » RDBMS Server » Server Administration » Display state database oracle 10g
Display state database oracle 10g [message #197143] Tue, 10 October 2006 04:44 Go to next message
svik
Messages: 16
Registered: April 2005
Location: MRU
Junior Member
Helllo everyone,

In oracle 10g rel 2, in which view and fields is stored the state of a database, that is, mount/nomount... open/close ?


Thanks
Re: Display state database oracle 10g [message #197151 is a reply to message #197143] Tue, 10 October 2006 05:01 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
SQL> select status from v$instance;

STATUS
---------
OPEN
Previous Topic: found dead multi-threaded server 'S011', pid = (28, 120)
Next Topic: SHARED SERVER TO DEDICATED CONNECTIONS
Goto Forum:
  


Current Time: Fri Dec 02 17:00:33 CST 2016

Total time taken to generate the page: 0.19365 seconds