DBA Data[Home] [Help]

VIEW: SYS.DBA_RESOURCE_INCARNATIONS

Source

View Text - Preformatted

select RESOURCE_TYPE, RESOURCE_NAME,
          DB_UNIQUE_NAME, DB_DOMAIN, INSTANCE_NAME, HOST_NAME,
          from_tz(STARTUP_TIME, '+00:00') at local as STARTUP_TIME
     from RECENT_RESOURCE_INCARNATIONS$
View Text - HTML Formatted

SELECT RESOURCE_TYPE
, RESOURCE_NAME
, DB_UNIQUE_NAME
, DB_DOMAIN
, INSTANCE_NAME
, HOST_NAME
, FROM_TZ(STARTUP_TIME
, '+00:00') AT LOCAL AS STARTUP_TIME
FROM RECENT_RESOURCE_INCARNATIONS$