| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
DBA_HIST_DATABASE_INSTANCE displays the databases and instances in the Workload Repository.
| Column | Datatype | NULL | Description |
|---|---|---|---|
DBID |
NUMBER |
NOT NULL |
Database ID |
INSTANCE_NUMBER |
NUMBER |
NOT NULL |
Instance number |
STARTUP_TIME |
TIMESTAMP(3) |
NOT NULL |
Startup time of the instance |
PARALLEL |
VARCHAR2(3) |
NOT NULL |
Indicates whether the instance is running in a RAC environment (YES) or not (NO) |
VERSION |
VARCHAR2(17) |
NOT NULL |
Database version |
DB_NAME |
VARCHAR2(9) |
Name of the database | |
INSTANCE_NAME |
VARCHAR2(16) |
Name of the instance | |
HOST_NAME |
VARCHAR2(64) |
Name of the host | |
LAST_ASH_SAMPLE_ID |
NUMBER |
NOT NULL |
Last sample ID for the active session history |
|
 Copyright © 2002, 2003, Oracle Corporation All Rights Reserved. |
|
