|
INSTANCE_NUMBER
|
NUMBER
|
Instance number used for instance registration. Corresponds to INSTANCE_NUMBER initialization parameter.
See Also: "INSTANCE_NUMBER"
|
|
INSTANCE_NAME
|
VARCHAR2(16)
|
Instance name
|
|
HOST_NAME
|
VARCHAR2(64)
|
Name of the host machine
|
|
VERSION
|
VARCHAR2(17)
|
RDBMS version
|
|
STARTUP_TIME
|
DATE
|
Time when instance was started up
|
|
STATUS
|
VARCHAR2(12)
|
Instance status:
STARTED: after STARTUP NOMOUNTMOUNTED: after STARTUP MOUNT or ALTER DATABASE CLOSEOPEN: after STARTUP or ALTER DATABASE OPENOPEN MIGRATE: after ALTER DATABASE OPEN MIGRATE
|
|
PARALLEL
|
VARCHAR2(3)
|
(YES/NO) Indicates whether the instance is mounted in cluster database mode
|
|
THREAD#
|
NUMBER
|
Redo thread opened by the instance
|
|
ARCHIVER
|
VARCHAR2(7)
|
(STOPPED | STARTED | FAILED) FAILED means that the archiver failed to archive a log last time, but will try again within 5 minutes
|
|
LOG_SWITCH_WAIT
|
VARCHAR2(11)
|
The ARCHIVE LOG/CLEAR LOG/CHECKPOINT event log switching is waiting for. Note that if ALTER SYSTEM SWITCH LOGFILE is hung, but there is room in the current online redo log, then value is NULL
|
|
LOGINS
|
VARCHAR2(10)
|
ALLOWED | RESTRICTED
|
|
SHUTDOWN_PENDING
|
VARCHAR2(3)
|
YES | NO
|
|
DATABASE_STATUS
|
VARCHAR2(17)
|
The status of the database
|
|
INSTANCE_ROLE
|
VARCHAR2(18)
|
Describes whether the instance is an active instance (PRIMARY_INSTANCE) or a inactive secondary instance (SECONDARY_INSTANCE), or UNKNOWN if the instance has been started but not mounted
|
|
ACTIVE_STATE
|
VARCHAR2(9)
|
(NORMAL|QUIESCING|QUIESCED).
NORMAL indicates the database is in a normal state.
QUIESCING indicates that the ALTER SYSTEM QUIESCE RESTRICTED statement has been issued: no new user transactions, queries, or PL/SQL statements are processed in this instance. User transactions, queries, or PL/SQL statements issued before the ALTER SYSTEM QUIESCE RESTRICTED statement are unaffected. DBA transactions, queries, or PL/SQL statements are also unaffected.
QUIESCED indicates that the ALTER SYSTEM QUIESCE RESTRICTED statement has been issued: no user transactions, queries, or PL/SQL statements are processed. DBA transactions, queries, or PL/SQL statements are unaffected. User transactions, queries, or PL/SQL statements issued after the ALTER SYSTEM QUIESCE RESTRICTED statement are not processed.
Note that a single ALTER SYSTEM QUIESCE RESTRICTED statement quiesces all instances in an Oracle9i Real Application Clusters environment. After this statement has been issued, some instances may enter into a quiesced state before other instances; the system is quiesced when all instances enter the quiesced state.
|
