DBA Data[Home] [Help] [Dependency Information]

TABLE: SYS.RECENT_RESOURCE_INCARNATIONS$

Object Details
Object Name: RECENT_RESOURCE_INCARNATIONS$
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: Tablespace
PCT Free: 0
PCT Used: 0
Primary Key: RECENT_RESOURCE_INCARNATIONS$P
  1. ColumnRESOURCE_TYPE
  2. ColumnDB_DOMAIN
  3. ColumnDB_UNIQUE_NAME
  4. ColumnINSTANCE_NAME
  5. ColumnINCARNATION
  6. ColumnSTARTUP_TIME
Indexes
Index Type Uniqueness Tablespace Column
RECENT_RESOURCE_INCARNATIONS$P IOT - TOP UNIQUE TablespaceSYSTEM ColumnRESOURCE_TYPE
ColumnDB_DOMAIN
ColumnDB_UNIQUE_NAME
ColumnINSTANCE_NAME
ColumnINCARNATION
ColumnSTARTUP_TIME
Columns
Name Datatype Length Mandatory Comments
RESOURCE_TYPE VARCHAR2 (30) Yes
RESOURCE_ID NUMBER

RESOURCE_NAME VARCHAR2 (256)
DB_UNIQUE_NAME VARCHAR2 (30) Yes
DB_DOMAIN VARCHAR2 (128) Yes
INSTANCE_NAME VARCHAR2 (30) Yes
HOST_NAME VARCHAR2 (512)
LOCATION VARCHAR2 (512)
INCARNATION VARCHAR2 (30) Yes
STARTUP_TIME TIMESTAMP(9) (11) Yes Resource startup date and time in universal time (UTC)
SHUTDOWN_TIME TIMESTAMP(9) (11)
Resource shutdown date and time in universal time (UTC)
DESCRIPTION VARCHAR2 (4000)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RESOURCE_TYPE
,      RESOURCE_ID
,      RESOURCE_NAME
,      DB_UNIQUE_NAME
,      DB_DOMAIN
,      INSTANCE_NAME
,      HOST_NAME
,      LOCATION
,      INCARNATION
,      STARTUP_TIME
,      SHUTDOWN_TIME
,      DESCRIPTION
FROM SYS.RECENT_RESOURCE_INCARNATIONS$;

Dependencies

[top of page]

SYS.RECENT_RESOURCE_INCARNATIONS$ does not reference any database object

SYS.RECENT_RESOURCE_INCARNATIONS$ is referenced by following:

SchemaSYS
ViewDBA_RESOURCE_INCARNATIONS
Package BodyDBMS_HA_ALERTS_PRVT - show dependent code