OraFAQ Forum: Server Administration » Display state database oracle 10g

Home » RDBMS Server » Server Administration » Display state database oracle 10g

Tue, 10 October 2006 04:44

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

Tue, 10 October 2006 05:01

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 Jan 10 23:56:07 CST 2025