Oracle：查看当前实例的信息
如果希望查看当前实例状态相关的信息，需要查询的数据字典表为：v$instance。
关于这个表，Oracle官方的联机文档中给出了详细的说明，描述了各个字段的可能值及其含义：http://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_2002.htm#REFRN30105
Eg:
|
1 2 3 4 5 6 7 8 9 |
SQL> col "Host name" for a12 SQL> set linesize 300 SQL> select instance_number "Ins.No",THREAD# "Thread",Instance_name "Ins.Name",status "Ins.Status",database_status "DB.Status",version "Ins.Ver",instance_role "Ins.Role",active_state "Active.Status",shutdown_pending as "Shutdown Pending",host_name "Host name",to_char(startup_time,'yyyy-mm-dd hh24:mi:ss') "Startup Time" from v$instance; Ins.No Thread Ins.Name Ins.Status DB.Status Ins.Ver Ins.Role Active.St Shu Host name Startup Time ---------- ---------- ---------------- ------------ ----------------- ----------------- ------------------ --------- --- ------------ -------------------- 1 1 misrepdb1 OPEN ACTIVE 10.2.0.5.0 PRIMARY_INSTANCE NORMAL NO misrep1 2014-06-10 10:05:11 SQL> |
————————————————————————————
Ending。
