Oracle 视图 DBA_WORKLOAD_REPLAY_SCHEDULES 官方解释,作用,如何使用详细说明
本站中文解释
Oracle 视图是在Oracle数据库中一种可视化的对象,DBA_WORKLOAD_REPLAY_SCHEDULES视图提供了查询和管理正在运行的负载重放的信息。它显示了每个应用程序、每块存储器、状态、预期的完成时间、所需的时间等。它可用于检查正在进行的负载重放任务,查看进度以及检测可能遇到的问题。
使用DBA_WORKLOAD_REPLAY_SCHEDULES视图可以通过以下语句:
SELECT *
FROM DBA_WORKLOAD_REPLAY_SCHEDULES;
官方英文解释
DBA_WORKLOAD_REPLAY_SCHEDULES
displays the names of replay schedules for the current replay directory.
A replay schedule defines one or multiple workload captures, and the order to start their replays. The current replay directory is set by DBMS_WORKLOAD_REPLAY.SET_REPLAY_DIRECTORY('replay_dir')
. Each row in the view contains information about one replay schedule.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
The name of a schedule to be replayed. It defines one or multiple workload captures, and the order to start their replays. |
|
|
|
Directory object name for the replay schedule name |
|
|
|
See Also:
-
“DBA_WORKLOAD_SCHEDULE_CAPTURES” displays the workload captures in a replay schedule.
-
“DBA_WORKLOAD_SCHEDULE_ORDERING” displays the order to start captures in a replay schedule.
-
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_WORKLOAD_REPLAY
package