[Home] [Help] [Dependency Information]

TABLE: SYS.WRM$_DATABASE_INSTANCE

Object Details

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: WRM$_DATABASE_INSTANCE_PK

1. DBID
2. INSTANCE_NUMBER
3. STARTUP_TIME

Indexes

Index	Type	Uniqueness	Tablespace	Column
WRM$_DATABASE_INSTANCE_PK	NORMAL	UNIQUE	SYSAUX	DBID INSTANCE_NUMBER STARTUP_TIME

Foreign Keys

Table		Foreign Table	Foreign Key Column
WRM$_SNAPSHOT		WRM$_DATABASE_INSTANCE	WRM$_SNAPSHOT DBID WRM$_SNAPSHOT INSTANCE_NUMBER WRM$_SNAPSHOT STARTUP_TIME

Columns

Query Text

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;

Dependencies

[top of page]

SYS.WRM$_DATABASE_INSTANCE does not reference any database object

SYS.WRM$_DATABASE_INSTANCE is referenced by following:

SYS

DBMS_SWRF_INTERNAL - show dependent code

INT$DBA_HIST_DATABASE_INSTANCE

PRVT_HDM - show dependent code