DBA Data[Home] [Help]

VIEW: SYS.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_ID" from INT$DBA_HIST_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_ID"
FROM INT$DBA_HIST_DATABASE_INSTANCE