Oracle教程 2023-02-24

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

本站中文解释

Oracle视图：DBA_HIST_CAPTURE

用途：DBA_HIST_CAPTURE视图提供了有关在启用和停用AWR捕获时间块的元数据信息。

使用方法：

1. 安装并启用AWR，然后在活动会话中执行

SQL> EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT;

2. 使用下面的查询语句检索DBA_HIST_CAPTURE视图的内容：

SELECT * FROM DBA_HIST_CAPTURE;

它将返回以下列：

BEGIN_INTERVAL_TIME — 开始捕获这个快照的时间戳

END_INTERVAL_TIME — 结束捕获这个快照的时间戳

ELAPSED_SECONDS — 上次快照到本次快照消耗的时间，以秒计算

WORKLOAD_REQUEST_COUNT — 在这个快照期间传递给数据库的工作负载请求数量

WORKLOAD_WORK_COUNT — 在这个快照期间处理的工作负载总数

WORKLOAD_CPU_SECONDS — 在快照间隔内消耗的CPU秒

WORKLOAD_UI_SECONDS — 在快照间隔内消耗的用户I/O秒

WORKLOAD_PI_SECONDS — 在快照间隔内消耗的操作系统I/O秒

WORKLOAD_DB_SECONDS — 在快照间隔内消耗的持续的数据库时间

WORKLOAD_NET_SECONDS — 在快照间隔内消耗的网络时间

官方英文解释

DBA_HIST_CAPTURE displays historical statistics information about each capture process for Oracle GoldenGate, and XStream capture operations.

This view is intended for use with Automatic Workload Repository (AWR).

Column	Datatype	NULL	Description
`SNAP_ID`	`NUMBER`	`NOT NULL`	Unique snapshot ID
`DBID`	`NUMBER`	`NOT NULL`	Database ID for the snapshot
`INSTANCE_NUMBER`	`NUMBER`	`NOT NULL`	Instance number for the snapshot
`CAPTURE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the capture process
`STARTUP_TIME`	`DATE`	`NOT NULL`	Time that the capture process was last started
`LAG`	`NUMBER`		Delay (in seconds) between the creation and capture of the most recently captured message
`TOTAL_MESSAGES_CAPTURED`	`NUMBER`		Total changes captured since the capture process was last started
`TOTAL_MESSAGES_ENQUEUED`	`NUMBER`		Total number of messages enqueued since the capture process was last started
`ELAPSED_RULE_TIME`	`NUMBER`		Elapsed time (in hundredths of a second) evaluating rules since the capture process was last started
`ELAPSED_ENQUEUE_TIME`	`NUMBER`		Elapsed time (in hundredths of a second) enqueuing messages since the capture process was last started
`ELAPSED_REDO_WAIT_TIME`	`NUMBER`		Elapsed time (in hundredths of a second) spent by the capture process in the WAITING FOR REDO state since the capture process was last started.
`ELAPSED_PAUSE_TIME`	`NUMBER`		Elapsed pause time (in hundredths of a second) spent by the capture process since the capture process was last restarted
`CON_DBID`	`NUMBER`		The database ID of the PDB
`EXTRACT_NAME`	`VARCHAR2(128)`		Name of the extract process, if applicable
`BYTES_REDO_MINED`	`NUMBER`		The total amount of redo data mined (in bytes) since the capture process last started
`BYTES_SENT`	`NUMBER`		Total number of bytes sent by the capture process to the extract process since the last time the extract process attached to the capture process
`SESSION_MODULE`	`VARCHAR2(64)`	`NOT NULL`	Session module. Valid values: XStream GoldenGate
`CON_ID`	`NUMBER`		The ID of the container to which the data pertains. 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_CAPTURE 官方解释，作用，如何使用详细说明

分享到：

本站中文解释

官方英文解释

相关推荐