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。