HomePage » Database » Oracle » OracleInstance


Oracle Instance


Check instance state:
SQL> select status from v$instance;

STATUS
------------------------------------
MOUNTED


Check instance startup time:
SQL> select startup_time from v$instance;

STARTUP_TIME
------------------------
01-SEP-11 17:45:39


Check instance name:
select INSTANCE_NAME from v$instance;

There are no comments on this page. [Add comment]

Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by WikkaWiki