Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\ratug\spa_upgrade008.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>Running SQL Performance Analyzer to Test a Database Upgrade from Oracle Database 10g Release 2 and Newer Releases</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="Running SQL Performance Analyzer to Test a Database Upgrade from Oracle Database 10g Release 2 and Newer Releases" /> <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_upgrade007.htm" title="Previous" type="text/html" /> <link rel="next" href="spa_upgrade009.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_upgrade007.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="spa_upgrade009.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDBHIHH" name="CHDBHIHH"></a><a id="RATUG299" name="RATUG299"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Running SQL Performance Analyzer to Test a Database Upgrade from Oracle Database 10<span class="italic">g</span> Release 2 and Newer Releases</h1> <a name="BEGIN" id="BEGIN"></a> <p><a id="sthref100" name="sthref100"></a>Once the SQL tuning set is transported to the SQL Performance Analyzer system, you can use SQL Performance Analyzer to build a pre-upgrade <a id="sthref101" name="sthref101"></a>SQL trial by executing or generating plans of SQL statements in the SQL tuning set on the test system. SQL Performance Analyzer test executes the SQL statements using a database link that you specify by connecting to the test system remotely and generating the execution plans and statistics for the SQL trial. The database link should exist on the SQL Performance Analyzer system and connect to a remote user with privileges to execute the SQL tuning set on the test system.</p> <p><a id="sthref102" name="sthref102"></a>After the pre-upgrade SQL trial is built, you need to upgrade the test system. Once the database has been upgraded, SQL Performance Analyzer will need to execute or generate plans of SQL statements in the SQL tuning set a second time on the upgraded test system to build a post-upgrade <a id="sthref103" name="sthref103"></a>SQL trial.</p> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="spa_upgrade009.htm#CHDJFGGD">Testing a Database Upgrade from Oracle Database 10<span class=italic">g</span> Release 2 and Newer Releases Using Enterprise Manager"</a></p> <p><a href="spa_upgrade007.htm#CIAJDJBD">Upgrading from Oracle Database 10<span class=italic">g</span> Release 2 and Newer Releases"</a></p> </div> <!-- 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_upgrade007.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="spa_upgrade009.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --></div> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de