Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_HIST_REPORTS_TIMEBANDS

DBA_HIST_REPORTS_TIMEBANDS contains bands of time with a new row created every day corresponding to a band of time. Each band of time represents a period of time, and has a row for every report captured automatically into Automatic Workload Repository (AWR) during that time. If the activity period of a report spans across two bands of time (for example. the activity started before midnight and ended after midnight), then the view contains two rows for that report, with one row for each band of time. The view is partitioned to provide fast access to all reports captured in a given time frame.

Column Datatype NULL Description
SNAP_ID NUMBER   The AWR snapshot id corresponding to the report
DBID NUMBER   Database ID of the current database for the report
INSTANCE_NUMBER NUMBER   Instance number (for an Oracle RAC system)
CON_DBID NUMBER   CDB ID of the captured report
COMPONENT_ID NUMBER   ID of the component (for example, SQL Monitor) whose report is captured
COMPONENT_NAME VARCHAR2(128)   Name of the component whose report is captured
BAND_START_TIME DATE   Starting time of the time band
BAND_LENGTH NUMBER   Length of time band in days (currently unused)
REPORT_ID NUMBER   ID of the captured report
REPORT_GENERATION_TIME DATE   Time when the report was generated
PERIOD_START_TIME DATE   Time when the activity period started
PERIOD_END_TIME DATE   Time when the activity period ended
KEY1 VARCHAR2(128)   Key1 associated with the captured report
KEY2 VARCHAR2(128)   Key2 associated with the captured report
KEY3 VARCHAR2(128)   Key3 associated with the captured report
KEY4 VARCHAR2(256)   Key4 associated with the captured report
SESSION_ID NUMBER   ID of the session corresponding to the captured report (currently used only for SQL Monitor reports)
SESSION_SERIAL# NUMBER   Session serial number corresponding to the captured report (currently used only for SQL Monitor reports)