DBA Data[Home] [Help]

VIEW: SYS.INT$DBA_HIST_REPORTS_TIMEBANDS

Source

View Text - Preformatted

select SNAP_ID, DBID, INSTANCE_NUMBER, CON_DBID, COMPONENT_ID, COMPONENT_NAME,
       BAND_START_TIME, BAND_LENGTH, REPORT_ID, REPORT_GENERATION_TIME,
       PERIOD_START_TIME, PERIOD_END_TIME, KEY1, KEY2, KEY3, KEY4, SESSION_ID,
       SESSION_SERIAL#, nvl(con_dbid_to_id(con_dbid), 0) CON_ID
from  wrp$_reports_time_bands
View Text - HTML Formatted

SELECT SNAP_ID
, DBID
, INSTANCE_NUMBER
, CON_DBID
, COMPONENT_ID
, COMPONENT_NAME
, BAND_START_TIME
, BAND_LENGTH
, REPORT_ID
, REPORT_GENERATION_TIME
, PERIOD_START_TIME
, PERIOD_END_TIME
, KEY1
, KEY2
, KEY3
, KEY4
, SESSION_ID
, SESSION_SERIAL#
, NVL(CON_DBID_TO_ID(CON_DBID)
, 0) CON_ID FROM WRP$_REPORTS_TIME_BANDS