[Home] [Help] [Dependency Information]
Object Name: | WRM$_DATABASE_INSTANCE |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WRM$_DATABASE_INSTANCE_PK | NORMAL | UNIQUE | SYSAUX |
DBID
INSTANCE_NUMBER STARTUP_TIME |
Table | |
Foreign Table | Foreign Key Column | WRM$_SNAPSHOT | WRM$_DATABASE_INSTANCE |
WRM$_SNAPSHOT
DBID
WRM$_SNAPSHOT INSTANCE_NUMBER WRM$_SNAPSHOT STARTUP_TIME |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DBID | NUMBER | Yes | ||
INSTANCE_NUMBER | NUMBER | Yes | ||
STARTUP_TIME | TIMESTAMP(3) | (11) | Yes | |
PARALLEL | VARCHAR2 | (3) | Yes | |
VERSION | VARCHAR2 | (17) | Yes | |
DB_NAME | VARCHAR2 | (9) | ||
INSTANCE_NAME | VARCHAR2 | (16) | ||
HOST_NAME | VARCHAR2 | (64) | ||
LAST_ASH_SAMPLE_ID | NUMBER | Yes | ||
PLATFORM_NAME | VARCHAR2 | (101) |
Cut, paste (and edit) the following text to query this object:
SELECT DBID
, INSTANCE_NUMBER
, STARTUP_TIME
, PARALLEL
, VERSION
, DB_NAME
, INSTANCE_NAME
, HOST_NAME
, LAST_ASH_SAMPLE_ID
, PLATFORM_NAME
FROM SYS.WRM$_DATABASE_INSTANCE;
SYS.WRM$_DATABASE_INSTANCE does not reference any database object
SYS.WRM$_DATABASE_INSTANCE is referenced by following:
|
|
|