Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\ratug\spa_upgrade009.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Testing a Database Upgrade from Oracle Database 10g Release 2 and Newer Releases Using Enterprise Manager</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" /> <meta name="date" content="2009-06-04T10:50:31Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Testing a Database Upgrade from Oracle Database 10g Release 2 and Newer Releases Using Enterprise Manager" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E12254-01" /> <link rel="copyright" href="./dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="./dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="prev" href="spa_upgrade008.htm" title="Previous" type="text/html" /> <link rel="next" href="spa_upgrade010.htm" title="Next" type="text/html" /> <script src="./callback.js" type="text/javascript"></script> <noscript>Your browser does not support JavaScript. This help page requires JavaScript to render correctly.</noscript> </head> <body> <div class="zz-skip-header"><a href="#BEGIN">Skip Headers</a></div> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="spa_upgrade008.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="spa_upgrade010.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDJFGGD" name="CHDJFGGD"></a><a id="RATUG300" name="RATUG300"></a></p> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h1>Testing a Database Upgrade from Oracle Database 10<span class="italic">g</span> Release 2 and Newer Releases Using Enterprise Manager</h1> <a name="BEGIN" id="BEGIN"></a> <p>To test a database upgrade from Oracle Database 10<span class="italic">g</span> Release 2 or a newer release using SQL Performance Analyzer:</p> <ol> <li> <p>On the Software and Support page, under Real Application Testing, click <span class="bold">SQL Performance Analyzer</span>.</p> <p>The SQL Performance Analyzer page appears.</p> </li> <li> <p>Under SQL Performance Analyzer Workflows, click <span class="bold">Upgrade from 10.2 or 11g</span>.</p> <p>The Upgrade from 10.2 or 11g page appears.</p> </li> <li> <p>Under Task Information:</p> <ol> <li> <p>In the Task Name field, enter the name of the task.</p> </li> <li> <p>In the SQL Tuning Set field, enter the name of the SQL tuning set that was built.</p> <p>Alternatively, click the search icon to search for the SQL tuning set using the Search and Select: SQL Tuning Set window.</p> <p>The selected SQL tuning set now appears in the SQL Tuning Set field.</p> </li> <li> <p>In the Description field, optionally enter a description of the task.</p> </li> </ol> </li> <li> <p>In the Creation Method field, select:</p> <ul> <li> <p><span class="bold">Execute SQLs</span> to generate both execution plans and statistics for each SQL statement in the SQL tuning set by actually running the SQL statements remotely on the test system over a public database link.</p> </li> <li> <p><span class="bold">Generate Plans</span> to create execution plans remotely on the test system over a public database link without actually running the SQL statements.</p> </li> </ul> </li> <li> <p>In the Per-SQL Time Limit list, determine the time limit for SQL execution during the trial by performing one of the following actions:</p> <ul> <li> <p>Select <span class="bold">5 minutes</span>.</p> <p>The execution will run each SQL statement in the SQL tuning set up to 5 minutes and gather performance data.</p> </li> <li> <p>Select <span class="bold">Unlimited</span>.</p> <p>The execution will run each SQL statement in the SQL tuning set to completion and gather performance data. Collecting execution statistics provides greater accuracy in the performance analysis but takes a longer time. Using this setting is not recommended because the task may be stalled by one SQL statement for a prolonged time period.</p> </li> <li> <p>Select <span class="bold">Customize</span> and enter the specified number of seconds, minutes, or hours.</p> </li> </ul> </li> <li> <p>In the Database Link field, enter the global name of a public database link connecting to a user with the <code>EXECUTE</code> privilege for the <code>DBMS_SQLPA</code> package and the <code>ADVISOR</code> privilege on the pre-upgrade system.</p> <p>Alternatively, click the search icon to search for and select a database link, or click <span class="bold">Create Database Link</span> to create a database link using the Create Database Link page.</p> </li> <li> <p>Under Post-upgrade Trial:</p> <ol> <li> <p>Select <span class="bold">Use the same system as in the pre-upgrade trial</span> to use the same system for executing both the pre-upgrade and post-upgrade trials.</p> <p>Oracle recommends using this option to avoid possible errors due to different system configurations. When using this option, you will need to upgrade the test database to the higher database version before the post-upgrade trial is executed.</p> </li> <li> <p>In the Database Link field, enter the global name of a public database link connecting to a user with the <code>EXECUTE</code> privilege for the <code>DBMS_SQLPA</code> package and the <code>ADVISOR</code> privilege on the post-upgrade system.</p> </li> </ol> </li> <li> <p>In the Comparison Metric list, select the comparison metric to use for the comparison analysis:</p> <ul> <li> <p><span class="bold">Elapsed Time</span></p> </li> <li> <p><span class="bold">CPU Time</span></p> </li> <li> <p><span class="bold">User I/O Time</span></p> </li> <li> <p><span class="bold">Buffer Gets</span></p> </li> <li> <p><span class="bold">Physical I/O</span></p> </li> <li> <p><span class="bold">Optimizer Cost</span></p> </li> <li> <p><span class="bold">I/O Interconnect Bytes</span></p> </li> </ul> <p>Optimizer Cost is the only comparison metric available if you generated execution plans only in the SQL trials.</p> <p>To perform the comparison analysis by using more than one comparison metric, perform separate comparison analyses by repeating this procedure with different metrics.</p> </li> <li> <p>Under Schedule:</p> <ol> <li> <p>In the Time Zone list, select your time zone code.</p> </li> <li> <p>Select <span class="bold">Immediately</span> to start the task now, or <span class="bold">Later</span> to schedule the task to start at a time specified using the Date and Time fields.</p> </li> </ol> </li> <li> <p>Click <span class="bold">Submit</span>.</p> <p>The SQL Performance Analyzer page appears.</p> <p>In the SQL Performance Analyzer Tasks section, the status of this task is displayed. To refresh the status icon, click <span class="bold">Refresh</span>.</p> <p>If you are using the same system to execute both the pre-upgrade and post-upgrade trials, you will need to upgrade the database after the pre-upgrade trial step is completed. After the database is upgraded, the post-upgrade trial can be executed. After the task completes, the Status field changes to Completed.</p> </li> <li> <p>Under SQL Performance Analyzer Tasks, select the task and click the link in the Name column.</p> <p>The SQL Performance Analyzer Task page appears.</p> <p>This page contains the following sections:</p> <ul> <li> <p>SQL Tuning Set</p> <p>This section summarizes information about the SQL tuning set, including its name, owner, description, and the number of SQL statements it contains.</p> </li> <li> <p>SQL Trials</p> <p>This section includes a table that lists the SQL trials used in the SQL Performance Analyzer task.</p> </li> <li> <p>SQL Trial Comparisons</p> <p>This section contains a table that lists the results of the SQL trial comparisons</p> </li> </ul> </li> <li> <p>Click the icon in the Comparison Report column.</p> <p>The SQL Performance Analyzer Task Result page appears.</p> </li> <li> <p>Review the results of the performance analysis, as described in <a href="spa_analyze003.htm#CACHAFHE">"Reviewing the SQL Performance Analyzer Report Using Oracle Enterprise Manager"</a>.</p> <p>If regressed SQL statements are found following the database upgrade, tune them as described in <a href="spa_upgrade010.htm#CIADFIIF">"Tuning Regressed SQL Statements After Testing a Database Upgrade"</a>.</p> </li> </ol> </div> <!-- class="sect3" --> <!-- class="sect2" --> <!-- class="sect1" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2008, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="./dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="spa_upgrade008.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="spa_upgrade010.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de