DBA_WORKLOAD_REPLAYS
displays all the workload replays that have been performed in the current database. It also lists replays on which DBMS_WORKLOAD_REPLAY.GET_REPLAY_INFO()
has been called. Each row contains information about one workload replay.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Internal key for the workload replay |
|
|
|
Name of the workload replay |
|
|
|
ID of the database in which the workload was replayed |
|
|
|
Name of the database in which the workload was replayed |
|
|
|
Version of the database in which the workload was replayed |
|
|
Indicates whether the database in which the workload was replayed was an Oracle RAC database ( |
|
|
|
|
Name of the directory object for the workload replay |
|
|
ID of the capture ( |
|
|
|
|
Current status of the workload replay:
|
|
|
Datetime at which the workload prepare started |
|
|
|
Datetime when the replay began |
|
|
|
Datetime when the replay completed or cancelled; NULL if the replay is still in progress |
|
|
|
Duration of the workload replay (in seconds) |
|
|
|
|
Number of workload replay client processes that were used in this workload replay |
|
|
|
Number of workload replay client processes that have finished replay |
|
|
Name of the filter set used for the replay |
|
|
|
|
Reserved for future use |
|
|
Indicates whether recorded transaction semantics should be maintained ( When synchronization is on, the commit order observed during the original workload capture will be preserved. Every action that is replayed will be executed only after all of its dependent commits have been executed. Dependent commits are commits that were issued before the given action in the original workload capture. See Also: |
|
|
|
|
Connection time scaling factor for captured streams during replay. The value is interpreted as a percentage.The default value of 100 means 100 percent. See Also: |
|
|
|
Think time scaling factor for captured streams during replay. It scales the thinking time elapsed between two successive user calls from the same captured stream. The input is interpreted as a percentage. The default value of 100 means 100 percent. See Also: |
|
|
Indicates whether the think time should be automatically corrected between calls ( A value of A value of See Also: |
|
|
|
|
Before the multiple-capture replay, |
|
|
Total number of user calls replayed |
|
|
|
Accumulated database time (in microseconds) for the replay |
|
|
|
Accumulated network time for the replay (in microseconds) |
|
|
|
Accumulated think time (in microseconds) for the replay |
|
|
|
The total time (in seconds) that the replay has been paused (by calling the PAUSE_REPLAY procedure) |
|
|
|
Reserved for future use |
|
|
|
Database ID of the AWR snapshots that correspond to this workload replay. For replays that were performed in the current database, this value is equal to the current database's DBID. For replays that were performed in other databases, this value will either be NULL or will be populated by See Also: DBMS_WORKLOAD_REPLAY.IMPORT_AWR() in Oracle Database PL/SQL Packages and Types Reference |
|
|
|
Begin snapshot ID of the AWR snapshots that correspond to this workload replay |
|
|
|
End snapshot ID of the AWR snapshots that correspond to this workload replay |
|
|
|
Indicates whether the AWR snapshots that correspond to this workload replay have been exported using See Also: DBMS_WORKLOAD_REPLAY.EXPORT_AWR() in Oracle Database PL/SQL Packages and Types Reference |
|
|
|
Error code for this workload replay |
|
|
|
Error message for this workload replay |
|
|
|
|
Full directory path for the replay directory object |
|
|
A hash value computed based on the values of other columns in this view, such as the |
|
|
|
User name of the SQL tuning set owner |
|
|
|
Name of the SQL tuning set for this workload replay |
|
|
|
The name of a schedule to be replayed. It defines one or multiple workload captures, and the order to start their replays. If If See Also: |
|
|
|
Indicates whether replay divergence data have been loaded ( |
See Also:
Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_WORKLOAD_REPLAY
package