不死鳥のメモ

_ インスタンス情報

SQL> select * from v$instance  ;


INSTANCE_NUMBER INSTANCE_NAME    HOST_NAME           VERSION           STARTUP_ STATUS       PAR    THREAD# ARCHIVE LOG_SWITCH_WAIT LOGINS     SHU DATABASE_STATUS   INSTANCE_ROLE      ACTIVE_ST BLO        
--------------- ---------------- ------------------- ----------------- -------- ------------ --- ---------- ------- --------------- ---------- --- ----------------- ------------------ --------- ---        
              1 ora              TEST                10.2.0.1.0        07-11-20 OPEN         NO           1 STOPPED                 ALLOWED    NO  ACTIVE            PRIMARY_INSTANCE   NORMAL    NO         

 名前                    NULL?    型
 ----------------------- -------- ----------------
 INSTANCE_NUMBER                  NUMBER
 INSTANCE_NAME                    VARCHAR2(16)
 HOST_NAME                        VARCHAR2(64)
 VERSION                          VARCHAR2(17)
 STARTUP_TIME                     DATE
 STATUS                           VARCHAR2(12)
 PARALLEL                         VARCHAR2(3)
 THREAD#                          NUMBER
 ARCHIVER                         VARCHAR2(7)
 LOG_SWITCH_WAIT                  VARCHAR2(15)
 LOGINS                           VARCHAR2(10)
 SHUTDOWN_PENDING                 VARCHAR2(3)
 DATABASE_STATUS                  VARCHAR2(17)
 INSTANCE_ROLE                    VARCHAR2(18)
 ACTIVE_STATE                     VARCHAR2(9)
 BLOCKED                          VARCHAR2(3)