Oracle9i Database Reference Release 2 (9.2) Part Number A96536-01 |
|
Dynamic Performance (V$) Views, 82 of 237
This view displays the state of the current 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 |
|
|
Instance status: |
|
|
( |
|
|
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, 2002 Oracle Corporation. All Rights Reserved. |
|