Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Dynamic Performance (V$) Views, 83 of 211
This view displays the state of the current instance. This version of V$INSTANCE
is not compatible with earlier versions of V$INSTANCE
.
Column | Datatype | Description |
---|---|---|
|
|
Instance number used for instance registration. Corresponds to See Also: "INSTANCE_NUMBER" |
|
|
Instance name |
|
|
Name of the host machine |
|
|
RDBMS version |
|
|
Time when instance was started up |
|
|
|
|
|
( |
|
|
Redo thread opened by the instance |
|
|
( |
|
|
The |
|
|
|
|
|
|
|
|
The status of the database |
|
|
Describes whether the instance is an active instance ( |
|
|
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. |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|