Oracle 视图 V$WORKLOAD_REPLAY_THREAD 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图V$WORKLOAD_REPLAY_THREAD是统计归档重放工作负载中活动线程和执行进程的一个动态系统视图，它显示当前正在复制数据库活动的线程和进程的状态以及归档重放进度。
如何使用：
1、我们可以通过V$WORKLOAD_REPLAY_THREAD查看重放工作中的线程和进程的信息，包括重放状态、处理的重放数据（归档）、重放工作负载的完成进度等。
2、主要使用V$WORKLOAD_REPLAY_THREAD视图来控制和监视归档重放工作负载的进程，它可以指导我们排查和解决重放过程中遇到的问题。
3、另外，我们也可以使用V$WORKLOAD_REPLAY_THREAD视图统计重放操作的总耗时，以判断重放活动是否采用了最优方案以及是否有潜在的效率方面的问题，并采取后续的措施改进。
官方英文解释
V$WORKLOAD_REPLAY_THREAD displays information for all the different types of replay sessions.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Current simulated SCN based on the SCN recorded at capture time |
|
|
|
Next stream ID that will increment the |
|
|
|
Session ID of the replay session |
|
|
|
Session serial number of the replay session |
|
|
|
The server process ID of the replay session |
|
|
|
Logon username of the replay session |
|
|
|
Logon time of the replay session |
|
|
|
Event name |
|
|
|
Event identifier |
|
|
|
Event operation code |
|
|
|
Text for event parameter 1 |
|
|
|
Value of event parameter 1 |
|
|
|
Text for event parameter 2 |
|
|
|
Value of event parameter 2 |
|
|
|
Text for event parameter 3 |
|
|
|
Value of event parameter 3 |
|
|
|
The captured SCN for which the current user call should wait |
|
|
|
The stream ID that is being replayed |
|
|
|
The call counter of the user call that is being replayed |
|
|
|
The dependent SCN, captured to order the commit actions using block-level dependencies |
|
|
|
Statement SCN |
|
|
|
The (maximum) SCN that the current commit should wait for |
|
|
|
The next SCN after the current commit |
|
|
|
The type of commits. The possible values are: |
|
|
|
The type of replay session:
|
|
|
|
Unique replay client ID assigned by the server to all participating replay clients when replay starts |
|
|
|
An unique identifier for a workload capture added to a replay schedule. A value of |
|
|
|
File name of the captured stream |
|
|
|
Whether or not the current replayed user call is skipped or not |
|
|
|
Reserved for internal use |
|
|
|
Accumulated database time for the replay session |
|
|
|
Accumulated network time for the replay session |
|
|
|
Accumulated think time for the replay session |
|
|
|
If nonzero, the accumulated time in macro seconds indicating how fast the replay is |
|
|
|
If nonzero, the accumulated time in macro seconds indicating how slow the replay is |
|
|
|
Total number of user calls |
|
|
|
Total number of PL/SQL calls recorded in the workload capture |
|
|
|
Total number of calls recorded in the workload capture for SQL executed from PL/SQL |
|
|
|
Total amount of database time in microseconds from PL/SQL calls that have been recorded in the workload capture |
|
|
|
Operating system username of the replay client |
|
|
|
Host name of the replay client |
|
|
|
Process ID of the replay client |
|
|
|
Program name of the replay client |
|
|
|
Total amount of elapsed time of a session since capture starts (in seconds) |
|
|
|
Total amount of elapsed time of a session since replay starts (in seconds) |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
