The Workload Analyzer is a Java program that analyzes a workload capture directory and identifies parts of a captured workload that may not replay accurately due to factors that include insufficient data, errors that occurred during workload capture, or usage of features that are not supported by Database Replay. The results of the workload analysis are saved to an HTML report named wcr_cap_analysis.html located in the capture directory that is being analyzed. If an error can be prevented, the workload analysis report displays available preventive actions that can be implemented before replay. If an error cannot be corrected, the workload analysis report provides a description of the error so it can be accounted for during replay. Running Workload Analyzer is the default option and is strongly recommended.
If you are preprocessing a workload capture using Oracle Enterprise Manager Database Control 188.8.131.52 and above, then you do not need to run Workload Analyzer in the command-line interface. Oracle Enterprise Manager Database Control 184.108.40.206 and above enables you to run Workload Analyzer as part of the workload preprocessing.
The Workload Analyzer requires Java 1.5 or above. Workload Analyzer is composed of two JAR files, dbranalyzer.jar and dbrparser.jar, located in the $ORACLE_HOME/rdbms/jlib/ directory of an Oracle Database Enterprise Edition installation, version 220.127.116.11 and above. Those two files can also be downloaded from OTN here:
The Workload Analyzer also requires the ojdbc5.jar file located in the $ORACLE_HOME/jdbc/lib/ directory. To run Workload Analyzer in the command-line interface, run the following 'java' command on a single line:
For the capture_directory parameter, input the operating system path of the capture directory. This directory should also contain the exported AWR data for the workload capture. For the connection_string parameter, input the connection string of an Oracle database that is release 11.1 or higher.
The Workload Analyzer program will then prompt you to input the username and password of a database user with EXECUTE privileges for the DBMS_WORKLOAD_CAPTURE package and the SELECT_CATALOG role on the target database.