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 |
|---|---|---|---|
|
|
| The numerical value that is associated with the subdirectory under the replay directory. See |
|
| The instance where the commit is executed | |
|
|
| The file ID |
|
|
| The call counter of the commit |
|
| The recorded commit SCN value | |
|
| The file ID of the latest commit across all sessions | |
|
| The recorded SCN of the latest commit across all sessions | |
|
| The call counter of the latest commit in the same session | |
|
| The time in seconds since the capture started | |
|
| The elapsed time in seconds since the previous commit across all sessions during capture | |
|
| The time in seconds since the replay started | |
|
| The elapsed time in seconds since the previous commit across all sessions during the replay |
See Also:
DBA_WORKLOAD_REPLAYS
标签：视图,事务,性能,英文,可以使用