9.135 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 This column is available starting with Oracle Database 12c Release 2 (12.2.0.1). |
|
|
|
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 This column is available starting with Oracle Database 12c Release 2 (12.2.0.1). |
|
|
|
Total number of calls recorded in the workload capture for SQL executed from PL/SQL This column is available starting with Oracle Database 12c Release 2 (12.2.0.1). |
|
|
|
Total amount of database time in microseconds from PL/SQL calls that have been recorded in the workload capture This column is available starting with Oracle Database 12c Release 2 (12.2.0.1). |
|
|
|
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) This column is available starting with Oracle Database 12c Release 2 (12.2.0.1). |
|
|
|
Total amount of elapsed time of a session since replay starts (in seconds) This column is available starting with Oracle Database 12c Release 2 (12.2.0.1). |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|