Oracle教程 2023-02-25

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

Oracle视图DBA_WORKLOAD_TRACKED_COMMITS用于查看工作负载跟踪系统捕获的提交事务的信息，以监控系统的性能。其中可以查看各提交事务的开始和结束时间，查看间隔多长时间完成事务，和查看提交事务消耗的系统资源等等。

要使用DBA_WORKLOAD_TRACKED_COMMITS视图，需要先启用Oracle性能跟踪，并且必须是DBAM权限，才能查看这个视图。查看这个视图，可以使用sql语句：

SELECT * FROM DBA_WORKLOAD_TRACKED_COMMITS;

DBA_WORKLOAD_TRACKED_COMMITS displays the commits tracked every second during a database replay.

Column	Datatype	NULL	Description
`REPLAY_DIR_NUMBER`	`NUMBER`	`NOT NULL`	The numerical value that is associated with the subdirectory under the replay directory. See `REPLAY_DIR_NUMBER` in `DBA_WORKLOAD_REPLAYS`
`INSTANCE_NUMBER`	`NUMBER(38)`		The instance where the commit is executed
`FILE_ID`	`NUMBER(38)`	`NOT NULL`	The file ID
`CALL_CTR`	`NUMBER(38)`	`NOT NULL`	The call counter of the commit
`COMMIT_SCN`	`NUMBER(38)`		The recorded commit SCN value
`PREV_GLOBAL_COMMIT_FILE_ID`	`NUMBER(38)`		The file ID of the latest commit across all sessions
`PREV_GLOBAL_COMMIT_SCN`	`NUMBER(38)`		The recorded SCN of the latest commit across all sessions
`PREV_LOCAL_COMMIT_CALL_CTR`	`NUMBER(38)`		The call counter of the latest commit in the same session
`CAPTURE_COMMIT_TIME`	`NUMBER(38)`		The time in seconds since the capture started
`CAPTURE_COMMIT_TIME_DELTA`	`NUMBER(38)`		The elapsed time in seconds since the previous commit across all sessions during capture
`REPLAY_COMMIT_TIME`	`NUMBER(38)`		The time in seconds since the replay started
`REPLAY_COMMIT_TIME_DELTA`	`NUMBER(38)`		The elapsed time in seconds since the previous commit across all sessions during the replay