Oracle教程

Oracle 视图 DBA_HIST_REPORTS_TIMEBANDS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图DBA_HIST_REPORTS_TIMEBANDS显示了应用程序配置报告的处理的起止时间。该视图是AWR(Automatic Workload Repository，自动工作负载存储库)系统表的一部分，表示定义的处理开始时间。这些数据以小时为单位，将报告拆分为单个24小时时段。如果报告跨越数天，则会将报告拆分成几个24小时的时段。

使用DBA_HIST_REPORTS_TIMEBANDS视图，可以帮助DBA查找和了解报告的处理的起止时间，以识别报告范围内的活动，定期发布和处理报告时间段以及应用程序等等。

官方英文解释

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)

CON_ID

NUMBER

The ID of the container that CON_DBID identifies. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data


数据运维技术 » Oracle 视图 DBA_HIST_REPORTS_TIMEBANDS 官方解释，作用，如何使用详细说明
分享到：

相关推荐