Real Application Testing - Database Replay
Workload Analyzer Command-Line Interface

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.
--------------------------------------------------------------------------------------
Note:
If you are preprocessing a workload capture using Oracle Enterprise Manager Database Control 11.2.0.2 and above, then you do not need to run Workload Analyzer in the command-line interface. Oracle Enterprise Manager Database Control 11.2.0.2 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 11.2.0.2 and above.   Those two files can also be downloaded from OTN here:
workloadanalyzer.zip
 
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:

java -classpath $ORACLE_HOME/jdbc/lib/ojdbc5.jar:$ORACLE_HOME/rdbms/jlib/dbrparser.jar:$ORACLE_HOME/rdbms/jlib/dbranalyzer.jar: oracle.dbreplay.workload.checker.CaptureChecker <capture_directory> <connection_string>

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.
An example of the command would be:

java -classpath $ORACLE_HOME/jdbc/lib/ojdbc5.jar:$ORACLE_HOME/rdbms/jlib/dbrparser.jar:$ORACLE_HOME/rdbms/jlib/dbranalyzer.jar: oracle.dbreplay.workload.checker.CaptureChecker /scratch/capture jdbc:oracle:thin:@myhost.mycompany.com:1521:orcl
 
OpenworldDatabaseBanner

Oracle has a very active research organization (Oracle Labs) that is charged to 'Identify, explore, and transfer new technologies that have the potential to substantially improve Oracle's business'. One part of the organization is the External Research Office (ERO). The ERO is charged to ' ... invest in research collaborations that fit Oracle's long-term strategic goals. These collaborations are between university researchers and engineers/researchers throughout Oracle's various organizations'. The ERO webpage lists numerous current and past collaborations. Oracle provides funds and direct interactions with highly experienced developers.

If you are interested in the ERO program please contact Steve Jeffreys at
eroadmin_us_grp@oracle.com

If you would like to explore opportunities for a research collaboration with the database team please contact Dieter Gawlick at
dieter.gawlick@oracle.com


or Garret Swart at
garret.swart@oracle.com
.
Oracle Database Cloud