Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\ratug\target.db
<?xml version="1.0" encoding="UTF-8"?> <div element="book" href="toc.htm" number="" targetptr=""> <ttl>Oracle Database Real Application Testing User's Guide</ttl> <xreftext><cite> Oracle Database Real Application Testing User's Guide</cite></xreftext> <div element="chapter" href="rat_intro.htm" number="1" targetptr="RATUG101"> <ttl>Introduction to Oracle Real Application Testing</ttl> <xreftext>“Introduction to Oracle Real Application Testing”</xreftext> <div element="sect1" href="rat_intro001.htm" number="1.1" targetptr="RATUG102"> <ttl>Database Replay</ttl> <xreftext>“Database Replay”</xreftext> </div> <div element="sect1" href="rat_intro002.htm" number="1.2" targetptr="RATUG103"> <ttl>SQL Performance Analyzer</ttl> <xreftext>“SQL Performance Analyzer”</xreftext> </div> </div> <div element="chapter" href="dbr_intro.htm" number="2" targetptr="RATUG104"> <ttl>Introduction to Database Replay</ttl> <xreftext>“Introduction to Database Replay”</xreftext> <obj element="bridgehead" href="dbr_intro.htm" number="" targetptr="RATUG254"> <ttl>To analyze the effect of system changes using Database Replay:</ttl> <xreftext>“To analyze the effect of system changes using Database Replay:”</xreftext> </obj> <div element="sect1" href="dbr_intro001.htm" number="2.1" targetptr="RATUG105"> <ttl>Workload Capture</ttl> <xreftext>“Workload Capture”</xreftext> </div> <div element="sect1" href="dbr_intro002.htm" number="2.2" targetptr="RATUG106"> <ttl>Workload Preprocessing</ttl> <xreftext>“Workload Preprocessing”</xreftext> </div> <div element="sect1" href="dbr_intro003.htm" number="2.3" targetptr="RATUG107"> <ttl>Workload Replay</ttl> <xreftext>“Workload Replay”</xreftext> </div> <div element="sect1" href="dbr_intro004.htm" number="2.4" targetptr="RATUG108"> <ttl>Analysis and Reporting</ttl> <xreftext>“Analysis and Reporting”</xreftext> </div> </div> <div element="chapter" href="dbr_capture.htm" number="3" targetptr="RATUG109"> <ttl>Capturing a Database Workload</ttl> <xreftext>“Capturing a Database Workload”</xreftext> <div element="sect1" href="dbr_capture001.htm" number="3.1" targetptr="RATUG110"> <ttl>Prerequisites for Capturing a Database Workload</ttl> <xreftext>“Prerequisites for Capturing a Database Workload”</xreftext> </div> <div element="sect1" href="dbr_capture002.htm" number="3.2" targetptr="RATUG111"> <ttl>Workload Capture Options</ttl> <xreftext>“Workload Capture Options”</xreftext> <div element="sect2" href="dbr_capture003.htm" number="3.2.1" targetptr="RATUG112"> <ttl>Restarting the Database</ttl> <xreftext>“Restarting the Database”</xreftext> <obj element="bridgehead" href="dbr_capture003.htm" number="" targetptr="RATUG255"> <ttl>To restart all instances in a Oracle RAC configuration before workload capture:</ttl> <xreftext>“To restart all instances in a Oracle RAC configuration before workload capture:”</xreftext> </obj> </div> <div element="sect2" href="dbr_capture004.htm" number="3.2.2" targetptr="RATUG113"> <ttl>Using Filters with Workload Capture</ttl> <xreftext>“Using Filters with Workload Capture”</xreftext> </div> <div element="sect2" href="dbr_capture005.htm" number="3.2.3" targetptr="RATUG114"> <ttl>Setting Up the Capture Directory</ttl> <xreftext>“Setting Up the Capture Directory”</xreftext> </div> </div> <div element="sect1" href="dbr_capture006.htm" number="3.3" targetptr="RATUG115"> <ttl>Workload Capture Restrictions</ttl> <xreftext>“Workload Capture Restrictions”</xreftext> </div> <div element="sect1" href="dbr_capture007.htm" number="3.4" targetptr="RATUG117"> <ttl>Capturing a Database Workload Using Enterprise Manager</ttl> <xreftext>“Capturing a Database Workload Using Enterprise Manager”</xreftext> <obj element="bridgehead" href="dbr_capture007.htm" number="" targetptr="RATUG256"> <ttl>To capture a database workload using Enterprise Manager:</ttl> <xreftext>“To capture a database workload using Enterprise Manager:”</xreftext> </obj> </div> <div element="sect1" href="dbr_capture008.htm" number="3.5" targetptr="RATUG118"> <ttl>Monitoring Workload Capture Using Enterprise Manager</ttl> <xreftext>“Monitoring Workload Capture Using Enterprise Manager”</xreftext> <div element="sect2" href="dbr_capture009.htm" number="3.5.1" targetptr="RATUG119"> <ttl>Monitoring an Active Workload Capture</ttl> <xreftext>“Monitoring an Active Workload Capture”</xreftext> <obj element="bridgehead" href="dbr_capture009.htm" number="" targetptr="RATUG257"> <ttl>To monitor an active workload capture:</ttl> <xreftext>“To monitor an active workload capture:”</xreftext> </obj> </div> <div element="sect2" href="dbr_capture010.htm" number="3.5.2" targetptr="RATUG120"> <ttl>Stopping an Active Workload Capture</ttl> <xreftext>“Stopping an Active Workload Capture”</xreftext> <obj element="bridgehead" href="dbr_capture010.htm" number="" targetptr="RATUG258"> <ttl>To stop an active workload capture:</ttl> <xreftext>“To stop an active workload capture:”</xreftext> </obj> </div> <div element="sect2" href="dbr_capture011.htm" number="3.5.3" targetptr="RATUG121"> <ttl>Managing a Completed Workload Capture</ttl> <xreftext>“Managing a Completed Workload Capture”</xreftext> <obj element="bridgehead" href="dbr_capture011.htm" number="" targetptr="RATUG259"> <ttl>To manage a completed workload capture:</ttl> <xreftext>“To manage a completed workload capture:”</xreftext> </obj> </div> </div> </div> <div element="chapter" href="dbr_preprocess.htm" number="4" targetptr="RATUG128"> <ttl>Preprocessing a Database Workload</ttl> <xreftext>“Preprocessing a Database Workload”</xreftext> <div element="sect1" href="dbr_preprocess001.htm" number="4.1" targetptr="RATUG129"> <ttl>Preprocessing a Database Workload Using Enterprise Manager</ttl> <xreftext>“Preprocessing a Database Workload Using Enterprise Manager”</xreftext> <obj element="bridgehead" href="dbr_preprocess001.htm" number="" targetptr="RATUG260"> <ttl>To preprocess a captured workload using Enterprise Manager:</ttl> <xreftext>“To preprocess a captured workload using Enterprise Manager:”</xreftext> </obj> </div> </div> <div element="chapter" href="dbr_replay.htm" number="5" targetptr="RATUG131"> <ttl>Replaying a Database Workload</ttl> <xreftext>“Replaying a Database Workload”</xreftext> <div element="sect1" href="dbr_replay001.htm" number="5.1" targetptr="RATUG132"> <ttl>Setting Up the Test System</ttl> <xreftext>“Setting Up the Test System”</xreftext> <div element="sect2" href="dbr_replay002.htm" number="5.1.1" targetptr="RATUG133"> <ttl>Restoring the Database</ttl> <xreftext>“Restoring the Database”</xreftext> </div> <div element="sect2" href="dbr_replay003.htm" number="5.1.2" targetptr="RATUG134"> <ttl>Resetting the System Time</ttl> <xreftext>“Resetting the System Time”</xreftext> </div> </div> <div element="sect1" href="dbr_replay004.htm" number="5.2" targetptr="RATUG135"> <ttl>Steps for Replaying a Database Workload</ttl> <xreftext>“Steps for Replaying a Database Workload”</xreftext> <div element="sect2" href="dbr_replay005.htm" number="5.2.1" targetptr="RATUG136"> <ttl>Setting Up the Replay Directory</ttl> <xreftext>“Setting Up the Replay Directory”</xreftext> </div> <div element="sect2" href="dbr_replay006.htm" number="5.2.2" targetptr="RATUG137"> <ttl>Resolving References to External Systems</ttl> <xreftext>“Resolving References to External Systems”</xreftext> </div> <div element="sect2" href="dbr_replay007.htm" number="5.2.3" targetptr="RATUG138"> <ttl>Remapping Connections</ttl> <xreftext>“Remapping Connections”</xreftext> </div> <div element="sect2" href="dbr_replay008.htm" number="5.2.4" targetptr="RATUG139"> <ttl>Specifying Replay Options</ttl> <xreftext>“Specifying Replay Options”</xreftext> <div element="sect3" href="dbr_replay009.htm" number="5.2.4.1" targetptr="RATUG140"> <ttl>Preserving COMMIT Order</ttl> <xreftext>“Preserving COMMIT Order”</xreftext> </div> <div element="sect3" href="dbr_replay010.htm" number="5.2.4.2" targetptr="RATUG141"> <ttl>Controlling Session Logins</ttl> <xreftext>“Controlling Session Logins”</xreftext> </div> <div element="sect3" href="dbr_replay011.htm" number="5.2.4.3" targetptr="RATUG142"> <ttl>Controlling Think Time</ttl> <xreftext>“Controlling Think Time”</xreftext> </div> </div> <div element="sect2" href="dbr_replay012.htm" number="5.2.5" targetptr="RATUG261"> <ttl>Using Filters with Workload Replay</ttl> <xreftext>“Using Filters with Workload Replay”</xreftext> </div> <div element="sect2" href="dbr_replay013.htm" number="5.2.6" targetptr="RATUG143"> <ttl>Setting Up Replay Clients</ttl> <xreftext>“Setting Up Replay Clients”</xreftext> <div element="sect3" href="dbr_replay014.htm" number="5.2.6.1" targetptr="RATUG144"> <ttl>Calibrating Replay Clients</ttl> <xreftext>“Calibrating Replay Clients”</xreftext> </div> <div element="sect3" href="dbr_replay015.htm" number="5.2.6.2" targetptr="RATUG145"> <ttl>Starting Replay Clients</ttl> <xreftext>“Starting Replay Clients”</xreftext> </div> <div element="sect3" href="dbr_replay016.htm" number="5.2.6.3" targetptr="RATUG146"> <ttl>Displaying Host Information</ttl> <xreftext>“Displaying Host Information”</xreftext> </div> </div> </div> <div element="sect1" href="dbr_replay017.htm" number="5.3" targetptr="RATUG147"> <ttl>Replaying a Database Workload Using Enterprise Manager</ttl> <xreftext>“Replaying a Database Workload Using Enterprise Manager”</xreftext> <obj element="bridgehead" href="dbr_replay017.htm" number="" targetptr="RATUG262"> <ttl>To replay a database workload using Enterprise Manager:</ttl> <xreftext>“To replay a database workload using Enterprise Manager:”</xreftext> </obj> </div> <div element="sect1" href="dbr_replay018.htm" number="5.4" targetptr="RATUG148"> <ttl>Monitoring Workload Replay Using Enterprise Manager</ttl> <xreftext>“Monitoring Workload Replay Using Enterprise Manager”</xreftext> <div element="sect2" href="dbr_replay019.htm" number="5.4.1" targetptr="RATUG149"> <ttl>Monitoring an Active Workload Replay</ttl> <xreftext>“Monitoring an Active Workload Replay”</xreftext> <obj element="bridgehead" href="dbr_replay019.htm" number="" targetptr="RATUG263"> <ttl>To monitor an active workload replay:</ttl> <xreftext>“To monitor an active workload replay:”</xreftext> </obj> </div> <div element="sect2" href="dbr_replay020.htm" number="5.4.2" targetptr="RATUG150"> <ttl>Viewing a Completed Workload Replay</ttl> <xreftext>“Viewing a Completed Workload Replay”</xreftext> <obj element="bridgehead" href="dbr_replay020.htm" number="" targetptr="RATUG286"> <ttl>To view a completed workload replay:</ttl> <xreftext>“To view a completed workload replay:”</xreftext> </obj> </div> </div> </div> <div element="chapter" href="dbr_analyze.htm" number="6" targetptr="RATUG159"> <ttl>Analyzing Replayed Workload</ttl> <xreftext>“Analyzing Replayed Workload”</xreftext> <div element="sect1" href="dbr_analyze001.htm" number="6.1" targetptr="RATUG287"> <ttl>Using Workload Capture Reports</ttl> <xreftext>“Using Workload Capture Reports”</xreftext> <div element="sect2" href="dbr_analyze002.htm" number="6.1.1" targetptr="RATUG160"> <ttl>Generating Workload Capture Reports Using Enterprise Manager</ttl> <xreftext>“Generating Workload Capture Reports Using Enterprise Manager”</xreftext> <obj element="bridgehead" href="dbr_analyze002.htm" number="" targetptr="RATUG271"> <ttl>To generate a workload capture report using Enterprise Manager:</ttl> <xreftext>“To generate a workload capture report using Enterprise Manager:”</xreftext> </obj> </div> <div element="sect2" href="dbr_analyze003.htm" number="6.1.2" targetptr="RATUG162"> <ttl>Reviewing Workload Capture Reports</ttl> <xreftext>“Reviewing Workload Capture Reports”</xreftext> </div> </div> <div element="sect1" href="dbr_analyze004.htm" number="6.2" targetptr="RATUG288"> <ttl>Using Workload Replay Reports</ttl> <xreftext>“Using Workload Replay Reports”</xreftext> <div element="sect2" href="dbr_analyze005.htm" number="6.2.1" targetptr="RATUG163"> <ttl>Generating Workload Replay Reports Using Enterprise Manager</ttl> <xreftext>“Generating Workload Replay Reports Using Enterprise Manager”</xreftext> <obj element="bridgehead" href="dbr_analyze005.htm" number="" targetptr="RATUG272"> <ttl>To generate a workload replay report using Enterprise Manager:</ttl> <xreftext>“To generate a workload replay report using Enterprise Manager:”</xreftext> </obj> </div> <div element="sect2" href="dbr_analyze006.htm" number="6.2.2" targetptr="RATUG165"> <ttl>Reviewing Workload Replay Reports</ttl> <xreftext>“Reviewing Workload Replay Reports”</xreftext> </div> </div> <div element="sect1" href="dbr_analyze007.htm" number="6.3" targetptr="RATUG289"> <ttl>Using Replay Compare Period Reports</ttl> <xreftext>“Using Replay Compare Period Reports”</xreftext> <div element="sect2" href="dbr_analyze008.htm" number="6.3.1" targetptr="RATUG290"> <ttl>Generating Replay Compare Period Reports Using Enterprise Manager</ttl> <xreftext>“Generating Replay Compare Period Reports Using Enterprise Manager”</xreftext> <obj element="bridgehead" href="dbr_analyze008.htm" number="" targetptr="RATUG291"> <ttl>To generate a replay compare period report using Enterprise Manager:</ttl> <xreftext>“To generate a replay compare period report using Enterprise Manager:”</xreftext> </obj> </div> </div> </div> <div element="chapter" href="spa_intro.htm" number="7" targetptr="RATUG166"> <ttl>Introduction to SQL Performance Analyzer</ttl> <xreftext>“Introduction to SQL Performance Analyzer”</xreftext> <obj element="bridgehead" href="spa_intro.htm" number="" targetptr="RATUG273"> <ttl>To analyze the SQL performance effect of system changes using SQL Performance Analyzer:</ttl> <xreftext>“To analyze the SQL performance effect of system changes using SQL Performance Analyzer:”</xreftext> </obj> <div element="sect1" href="spa_intro001.htm" number="7.1" targetptr="RATUG167"> <ttl>Capturing the SQL Workload</ttl> <xreftext>“Capturing the SQL Workload”</xreftext> </div> <div element="sect1" href="spa_intro002.htm" number="7.2" targetptr="RATUG168"> <ttl>Setting Up the Test System</ttl> <xreftext>“Setting Up the Test System”</xreftext> </div> <div element="sect1" href="spa_intro003.htm" number="7.3" targetptr="RATUG169"> <ttl>Creating a SQL Performance Analyzer Task</ttl> <xreftext>“Creating a SQL Performance Analyzer Task”</xreftext> </div> <div element="sect1" href="spa_intro004.htm" number="7.4" targetptr="RATUG170"> <ttl>Measuring the Pre-Change SQL Performance</ttl> <xreftext>“Measuring the Pre-Change SQL Performance”</xreftext> </div> <div element="sect1" href="spa_intro005.htm" number="7.5" targetptr="RATUG171"> <ttl>Making a System Change</ttl> <xreftext>“Making a System Change”</xreftext> </div> <div element="sect1" href="spa_intro006.htm" number="7.6" targetptr="RATUG172"> <ttl>Measuring the Post-Change SQL Performance</ttl> <xreftext>“Measuring the Post-Change SQL Performance”</xreftext> </div> <div element="sect1" href="spa_intro007.htm" number="7.7" targetptr="RATUG173"> <ttl>Comparing Performance Measurements</ttl> <xreftext>“Comparing Performance Measurements”</xreftext> </div> <div element="sect1" href="spa_intro008.htm" number="7.8" targetptr="RATUG174"> <ttl>Fixing Regressed SQL Statements</ttl> <xreftext>“Fixing Regressed SQL Statements”</xreftext> </div> </div> <div element="chapter" href="spa_task.htm" number="8" targetptr="RATUG175"> <ttl>Creating an Analysis Task</ttl> <xreftext>“Creating an Analysis Task”</xreftext> <div element="sect1" href="spa_task001.htm" number="8.1" targetptr="RATUG176"> <ttl>Creating an Analysis Task Using Enterprise Manager</ttl> <xreftext>“Creating an Analysis Task Using Enterprise Manager”</xreftext> <div element="sect2" href="spa_task002.htm" number="8.1.1" targetptr="RATUG177"> <ttl>Using the Parameter Change Workflow</ttl> <xreftext>“Using the Parameter Change Workflow”</xreftext> <obj element="bridgehead" href="spa_task002.htm" number="" targetptr="RATUG274"> <ttl>To use the SQL Performance Analyzer parameter change workflow:</ttl> <xreftext>“To use the SQL Performance Analyzer parameter change workflow:”</xreftext> </obj> </div> <div element="sect2" href="spa_task003.htm" number="8.1.2" targetptr="RATUG293"> <ttl>Using the Exadata Simulation Workflow</ttl> <xreftext>“Using the Exadata Simulation Workflow”</xreftext> <obj element="bridgehead" href="spa_task003.htm" number="" targetptr="RATUG294"> <ttl>To use the SQL Performance Analyzer Exadata simulation workflow:</ttl> <xreftext>“To use the SQL Performance Analyzer Exadata simulation workflow:”</xreftext> </obj> </div> <div element="sect2" href="spa_task004.htm" number="8.1.3" targetptr="RATUG178"> <ttl>Using the Guided Workflow</ttl> <xreftext>“Using the Guided Workflow”</xreftext> <obj element="bridgehead" href="spa_task004.htm" number="" targetptr="RATUG275"> <ttl>To use the SQL Performance Analyzer task guided workflow:</ttl> <xreftext>“To use the SQL Performance Analyzer task guided workflow:”</xreftext> </obj> </div> </div> </div> <div element="chapter" href="spa_pre_change.htm" number="9" targetptr="RATUG180"> <ttl>Creating a Pre-Change SQL Trial</ttl> <xreftext>“Creating a Pre-Change SQL Trial”</xreftext> <div element="sect1" href="spa_pre_change001.htm" number="9.1" targetptr="RATUG181"> <ttl>Creating a Pre-Change SQL Trial Using Enterprise Manager</ttl> <xreftext>“Creating a Pre-Change SQL Trial Using Enterprise Manager”</xreftext> <obj element="bridgehead" href="spa_pre_change001.htm" number="" targetptr="RATUG276"> <ttl>To create a pre-change SQL trial using Enterprise Manager:</ttl> <xreftext>“To create a pre-change SQL trial using Enterprise Manager:”</xreftext> </obj> </div> </div> <div element="chapter" href="spa_post_change.htm" number="10" targetptr="RATUG183"> <ttl>Creating a Post-Change SQL Trial</ttl> <xreftext>“Creating a Post-Change SQL Trial”</xreftext> <div element="sect1" href="spa_post_change001.htm" number="10.1" targetptr="RATUG184"> <ttl>Creating a Post-Change SQL Trial Using Oracle Enterprise Manager</ttl> <xreftext>“Creating a Post-Change SQL Trial Using Oracle Enterprise Manager”</xreftext> <obj element="bridgehead" href="spa_post_change001.htm" number="" targetptr="RATUG277"> <ttl>To create a post-change SQL trial using Enterprise Manager:</ttl> <xreftext>“To create a post-change SQL trial using Enterprise Manager:”</xreftext> </obj> </div> </div> <div element="chapter" href="spa_analyze.htm" number="11" targetptr="RATUG186"> <ttl>Comparing SQL Trials</ttl> <xreftext>“Comparing SQL Trials”</xreftext> <div element="sect1" href="spa_analyze001.htm" number="11.1" targetptr="RATUG187"> <ttl>Comparing SQL Trials Using Oracle Enterprise Manager</ttl> <xreftext>“Comparing SQL Trials Using Oracle Enterprise Manager”</xreftext> <div element="sect2" href="spa_analyze002.htm" number="11.1.1" targetptr="RATUG188"> <ttl>Analyzing SQL Performance Using Oracle Enterprise Manager</ttl> <xreftext>“Analyzing SQL Performance Using Oracle Enterprise Manager”</xreftext> <obj element="bridgehead" href="spa_analyze002.htm" number="" targetptr="RATUG279"> <ttl>To analyze SQL performance using Enterprise Manager:</ttl> <xreftext>“To analyze SQL performance using Enterprise Manager:”</xreftext> </obj> </div> <div element="sect2" href="spa_analyze003.htm" number="11.1.2" targetptr="RATUG189"> <ttl>Reviewing the SQL Performance Analyzer Report Using Oracle Enterprise Manager</ttl> <xreftext>“Reviewing the SQL Performance Analyzer Report Using Oracle Enterprise Manager”</xreftext> <obj element="bridgehead" href="spa_analyze003.htm" number="" targetptr="RATUG280"> <ttl>To generate and review the SQL Performance Analyzer report:</ttl> <xreftext>“To generate and review the SQL Performance Analyzer report:”</xreftext> </obj> <div element="sect3" href="spa_analyze004.htm" number="11.1.2.1" targetptr="RATUG190"> <ttl>Reviewing the SQL Performance Analyzer Report: General Information</ttl> <xreftext>“Reviewing the SQL Performance Analyzer Report: General Information”</xreftext> <obj element="bridgehead" href="spa_analyze004.htm" number="" targetptr="RATUG281"> <ttl>To review general information:</ttl> <xreftext>“To review general information:”</xreftext> </obj> </div> <div element="sect3" href="spa_analyze005.htm" number="11.1.2.2" targetptr="RATUG191"> <ttl>Reviewing the SQL Performance Analyzer Report: Global Statistics</ttl> <xreftext>“Reviewing the SQL Performance Analyzer Report: Global Statistics”</xreftext> <obj element="bridgehead" href="spa_analyze005.htm" number="" targetptr="RATUG282"> <ttl>To review global statistics:</ttl> <xreftext>“To review global statistics:”</xreftext> </obj> </div> <div element="sect3" href="spa_analyze006.htm" number="11.1.2.3" targetptr="RATUG192"> <ttl>Reviewing the SQL Performance Analyzer Report: Global Statistics Details</ttl> <xreftext>“Reviewing the SQL Performance Analyzer Report: Global Statistics Details”</xreftext> <obj element="bridgehead" href="spa_analyze006.htm" number="" targetptr="RATUG283"> <ttl>To review global statistics details:</ttl> <xreftext>“To review global statistics details:”</xreftext> </obj> </div> </div> <div element="sect2" href="spa_analyze007.htm" number="11.1.3" targetptr="RATUG193"> <ttl>Tuning Regressed SQL Statements Using Oracle Enterprise Manager</ttl> <xreftext>“Tuning Regressed SQL Statements Using Oracle Enterprise Manager”</xreftext> <div element="sect3" href="spa_analyze008.htm" number="11.1.3.1" targetptr="RATUG194"> <ttl>Creating SQL Plan Baselines</ttl> <xreftext>“Creating SQL Plan Baselines”</xreftext> <obj element="bridgehead" href="spa_analyze008.htm" number="" targetptr="RATUG284"> <ttl>To create SQL plan baselines:</ttl> <xreftext>“To create SQL plan baselines:”</xreftext> </obj> </div> <div element="sect3" href="spa_analyze009.htm" number="11.1.3.2" targetptr="RATUG195"> <ttl>Running SQL Tuning Advisor</ttl> <xreftext>“Running SQL Tuning Advisor”</xreftext> <obj element="bridgehead" href="spa_analyze009.htm" number="" targetptr="RATUG285"> <ttl>To run SQL Tuning Advisor:</ttl> <xreftext>“To run SQL Tuning Advisor:”</xreftext> </obj> </div> </div> </div> </div> <div element="chapter" href="spa_upgrade.htm" number="12" targetptr="RATUG210"> <ttl>Testing a Database Upgrade</ttl> <xreftext>“Testing a Database Upgrade”</xreftext> <div element="sect1" href="spa_upgrade001.htm" number="12.1" targetptr="RATUG211"> <ttl>Upgrading from Oracle9i Database and Oracle Database 10g Release 1</ttl> <xreftext>“Upgrading from Oracle9<span class="italic">i</span> Database and Oracle Database 10<span class="italic">g</span> Release 1”</xreftext> <obj element="figure" href="spa_upgrade001.htm" number="12-1" targetptr="RATUG249"> <ttl>SQL Performance Analyzer Workflow for Database Upgrade from Oracle9i to Oracle Database 10g Release 2</ttl> <xreftext>“SQL Performance Analyzer Workflow for Database Upgrade from Oracle9i to Oracle Database 10g Release 2”</xreftext> </obj> <div element="sect2" href="spa_upgrade002.htm" number="12.1.1" targetptr="RATUG212"> <ttl>Enabling SQL Trace on the Production System</ttl> <xreftext>“Enabling SQL Trace on the Production System”</xreftext> </div> <div element="sect2" href="spa_upgrade003.htm" number="12.1.2" targetptr="RATUG213"> <ttl>Creating a Mapping Table</ttl> <xreftext>“Creating a Mapping Table”</xreftext> </div> <div element="sect2" href="spa_upgrade004.htm" number="12.1.3" targetptr="RATUG214"> <ttl>Building a SQL Tuning Set</ttl> <xreftext>“Building a SQL Tuning Set”</xreftext> <obj element="table" href="spa_upgrade004.htm" number="12-1" targetptr="RATUG250"> <ttl>DBMS_SQLTUNE.SELECT_SQL_TRACE Function Parameters</ttl> <xreftext>“DBMS_SQLTUNE.SELECT_SQL_TRACE Function Parameters”</xreftext> </obj> </div> <div element="sect2" href="spa_upgrade005.htm" number="12.1.4" targetptr="RATUG296"> <ttl>Running SQL Performance Analyzer to Test a Database Upgrade from Oracle9i Database and Oracle Database 10g Release 1</ttl> <xreftext>“Running SQL Performance Analyzer to Test a Database Upgrade from Oracle9<span class="italic">i</span> Database and Oracle Database 10<span class="italic">g</span> Release 1”</xreftext> <div element="sect3" href="spa_upgrade006.htm" number="12.1.4.1" targetptr="RATUG297"> <ttl>Testing a Database Upgrade from Oracle9i Database and Oracle Database 10g Release 1 Using Enterprise Manager</ttl> <xreftext>“Testing a Database Upgrade from Oracle9<span class="italic">i</span> Database and Oracle Database 10<span class="italic">g</span> Release 1 Using Enterprise Manager”</xreftext> </div> </div> </div> <div element="sect1" href="spa_upgrade007.htm" number="12.2" targetptr="RATUG221"> <ttl>Upgrading from Oracle Database 10g Release 2 and Newer Releases</ttl> <xreftext>“Upgrading from Oracle Database 10<span class="italic">g</span> Release 2 and Newer Releases”</xreftext> <div element="sect2" href="spa_upgrade008.htm" number="12.2.1" targetptr="RATUG299"> <ttl>Running SQL Performance Analyzer to Test a Database Upgrade from Oracle Database 10g Release 2 and Newer Releases</ttl> <xreftext>“Running SQL Performance Analyzer to Test a Database Upgrade from Oracle Database 10<span class="italic">g</span> Release 2 and Newer Releases”</xreftext> <div element="sect3" href="spa_upgrade009.htm" number="12.2.1.1" targetptr="RATUG300"> <ttl>Testing a Database Upgrade from Oracle Database 10g Release 2 and Newer Releases Using Enterprise Manager</ttl> <xreftext>“Testing a Database Upgrade from Oracle Database 10<span class="italic">g</span> Release 2 and Newer Releases Using Enterprise Manager”</xreftext> </div> </div> </div> <div element="sect1" href="spa_upgrade010.htm" number="12.3" targetptr="RATUG228"> <ttl>Tuning Regressed SQL Statements After Testing a Database Upgrade</ttl> <xreftext>“Tuning Regressed SQL Statements After Testing a Database Upgrade”</xreftext> </div> </div> </div>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de