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

SCHEDULE_NAME

VARCHAR2(128)

NOT NULL

The name of a schedule to be replayed. It defines one or multiple workload captures, and the order to start their replays.

DIRECTORY

VARCHAR2(128)

NOT NULL

Directory object name for the replay schedule name

STATUS

VARCHAR2(128)

NEW if the schedule is being created, CURRENT if the schedule is currently being used by a replay, otherwise NULL

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 the DBMS_WORKLOAD_REPLAY package


数据运维技术 » Oracle 视图 DBA_WORKLOAD_REPLAY_SCHEDULES 官方解释,作用,如何使用详细说明