Oracle 视图 DBA_WORKLOAD_REPLAY_DIVERGENCE 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图DBA_WORKLOAD_REPLAY_DIVERGENCE用于展示回放峰值时各个样本及其相距度量作出比较。
用途:DBA_WORKLOAD_REPLAY_DIVERGENCE视图用于识别回放结果中的重要变化。它可以监控回放过程中比原始加载更多或更少的数据,SQL执行的不同,占用的内存量不同,甚至行行影响的变化等,使得数据库管理员可以及时发现由于在重记录时执行不正确的SQL而影响峰值的回放效果的差异等,从而缩短回放的时间,进一步改善重放性能。
使用方法:首先连接到数据库,然后查询该视图:SELECT * FROM DBA_WORKLOAD_REPLAY_DIVERGENCE;可以看到表中有多列数据,比如GAME_ID,AVG_DIFF_VALUE_LB和AVG_DIFF_VALUE_UB等等,这些列代表了每个重放样本之间的相距度量,可以通过这些数据来检查重放的效果。
官方英文解释
DBA_WORKLOAD_REPLAY_DIVERGENCE
displays information about data/error divergence for a user call that has been replayed.
DBA_WORKLOAD_DIV_SUMMARY
displays a summary of the replay divergence information in the DBA_WORKLOAD_REPLAY_DIVERGENCE
view. DBA_WORKLOAD_REPLAY_DIVERGENCE
may have duplicate entries, while DBA_WORKLOAD_DIV_SUMMARY
keeps only one entry and tracks the number of occurrences of each duplicate entry.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
ID (key) for the workload replay |
|
|
Time that the divergence occurred |
|
|
|
|
Reserved for future use |
|
|
Indicates whether the data divergence is from the number of rows fetched by |
|
|
|
Indicates whether the divergence is from the number of rows affected by |
|
|
|
Indicates whether the divergence is from errors seen during capture or replay ( |
|
|
|
Indicates whether the divergence is from sessions that failed during replay ( |
|
|
|
Indicates whether the SQL call contains masked bind data (Y) or not (N). If data masking technology is used at the replay database, the workload capture files need to be masked. Otherwise, SQL statements generated from capture files that contain sensitive bind data will not match the database. When the replay client sends masked bind data to the server, it turns on the |
|
|
|
Indicates whether the workload replay client failed during replay ( |
|
|
|
Number of rows fetched for |
|
|
|
Actual number of rows fetched for |
|
|
|
Error number that was seen during capture ( |
|
|
|
Text of the error message whose number appears in the |
|
|
|
Actual error number seen during replay ( |
|
|
|
Text of the error message whose number appears in the |
|
|
|
|
Stream ID of the session that reported the divergence |
|
|
|
Call counter of the user call that reported the divergence |
|
|
Internal ID of the capture file whose replay produced the divergence |
|
|
|
SQL ID of the SQL that reported the divergence |
|
|
|
|
Session ID of the session that reported the divergence |
|
|
|
Captured session serial number of the session that reported the divergence |
|
|
Service name of the session that reported the divergence |
|
|
|
Module name of the session that reported the divergence |
|
|
|
Action name of the session that reported the divergence |
|
|
|
The number of the instance that reported the divergence |
|
|
|
The identifier of the workload replay client |
See Also:
“DBA_WORKLOAD_DIV_SUMMARY”