DBA Data[Home] [Help]

VIEW: SYS.INT$DBA_HIST_DATABASE_INSTANCE

Source

View Text - Preformatted

select dbid, instance_number, startup_time, parallel, version,
       db_name, instance_name, host_name, last_ash_sample_id,
       platform_name, con_dbid_to_id(dbid) con_id
from WRM$_DATABASE_INSTANCE
View Text - HTML Formatted

SELECT DBID
, INSTANCE_NUMBER
, STARTUP_TIME
, PARALLEL
, VERSION
, DB_NAME
, INSTANCE_NAME
, HOST_NAME
, LAST_ASH_SAMPLE_ID
, PLATFORM_NAME
, CON_DBID_TO_ID(DBID) CON_ID FROM WRM$_DATABASE_INSTANCE