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

VIEW: SYS.CDB_RESOURCE_INCARNATIONS

Object Details
Object Name: CDB_RESOURCE_INCARNATIONS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Resource incarnations that are running or eligible for HA status notification in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_TYPE VARCHAR2 (30) Yes Resource type
RESOURCE_NAME VARCHAR2 (256)
Resource name
DB_UNIQUE_NAME VARCHAR2 (30) Yes Databae unique name
DB_DOMAIN VARCHAR2 (128) Yes Database domain
INSTANCE_NAME VARCHAR2 (30) Yes Name of instance at which resource is located
HOST_NAME VARCHAR2 (512)
Name of host at which resource is located
STARTUP_TIME TIMESTAMP(9) WITH TIME ZONE (20)
Resource startup date and time
CON_ID NUMBER

container id
Query Text

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


SELECT RESOURCE_TYPE
,      RESOURCE_NAME
,      DB_UNIQUE_NAME
,      DB_DOMAIN
,      INSTANCE_NAME
,      HOST_NAME
,      STARTUP_TIME
,      CON_ID
FROM SYS.CDB_RESOURCE_INCARNATIONS;

Dependencies

[top of page]

SYS.CDB_RESOURCE_INCARNATIONS does not reference any database object

SYS.CDB_RESOURCE_INCARNATIONS is referenced by following:

SchemaPUBLIC
SynonymCDB_RESOURCE_INCARNATIONS