Capture a workload in 10g for 11g

Oracle Tips by Burleson Consulting
March 3, 2008

Question: Is it possible to capture a workload in Oracle 10g, and then move it to Oracle 11g for execution testing?

Answer: Workload management is a major new approach for Oracle, away from contrived test cases, and into testing with empirical, real-world workloads. Lutz Hartmann notes in his book "Oracle 11g New Features", that you can indeed capture a workload in Oracle 10g and transport it to Oracle 11g.

In 10.2.0.4 a new parameter is used to enable workload capturing:

LUTZ AS SYSDBA @ orcl10g SQL> show parameter pre_11

NAME TYPE VALUE
��
pre_11g_enable_capture boolean FALSE

The PRE_11G_ENABLE_CAPTURE initialization parameter can only be used with Oracle Database 10g Release 2 (10.2). This parameter is not valid in subsequent releases. After upgrading the database, you will need to remove the parameter from the server parameter file (spfile) or the initialization parameter file (init.ora); otherwise, the database will fail to start up.

Oracle even has created the script $ORACLE_HOME/rdbms/admin/wrrenbl.sql which can be used to modity the parameter. The script to disable workload capture is $ORACLE_HOME/rdbms/admin/wrrdsbl.sql.

The package DBMS_WORKLOAD_CAPTURE has been added to the 10g RDBMS.

If you like Oracle tuning, you might enjoy my book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

��

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books