Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\ratug\spa_task003.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>Using the Exadata Simulation Workflow</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="Using the Exadata Simulation Workflow" /> <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_task002.htm" title="Previous" type="text/html" /> <link rel="next" href="spa_task004.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_task002.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="spa_task004.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CIHICAIJ" name="CIHICAIJ"></a><a id="RATUG293" name="RATUG293"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Using the Exadata Simulation Workflow</h1> <a name="BEGIN" id="BEGIN"></a> <p><a id="sthref46" name="sthref46"></a>The Exadata simulation workflow enables you to simulate the effects of an Exadata Storage Server installation on the performance of a SQL workload.</p> <p>Oracle Exadata provides extremely large I/O bandwidth coupled with a capability to offload SQL processing from the database to storage. This allows Oracle Database to significantly reduce the volume of data sent through the I/O interconnect, while at the same offload CPU resources to the Exadata storage cells.</p> <p>SQL Performance Analyzer can analyze the effectiveness of Exadata SQL offload processing by simulating an Exadata Storage Server installation and measuring the reduction in I/O interconnection on the SQL workload.</p> <p>Running the Exadata simulation does not require any hardware or configuration changes to your system. After you select a SQL tuning set, SQL Performance Analyzer creates a task and performs an initial trial with the Exadata Storage Server simulation disabled. SQL Performance Analyzer then performs a second trial with the Exadata Storage Server simulation enabled. SQL Performance Analyzer then compares the two trials using the I/O Interconnect Bytes comparison metric and generates a SQL Performance Analyzer report, which estimates the amount of data that would not need to be sent from the Exadata storage cells to the database if Oracle Exadata is being used.</p> <a id="RATUG294" name="RATUG294"></a> <p class="subhead2">To use the SQL Performance Analyzer Exadata simulation workflow:</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">Exadata Simulation</span>.</p> <p>The Exadata Simulation page appears.</p> </li> <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 contains the SQL workload to be analyzed.</p> <p>Alternatively, click the search icon to search for a 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> <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 Schedule section:</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>. After the task completes, the Status field changes to Completed.</p> </li> <li> <p>In the SQL Performance Analyzer Tasks section, 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>Any SQL performance improvement with the Exadata simulation between the first and second trials is captured in the report. In general, you can expect a greater impact if the SQL workload contains queries that returns a large number of rows. Conversely, a SQL workload that queries indexed tables or tables with fewer rows will result in a lesser impact from the Exadata simulation.</p> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="spa_task001.htm#BABDBCDH">Creating an Analysis Task Using Enterprise Manager</a></p> </div> </div> <!-- class="sect2" --> <!-- 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_task002.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="spa_task004.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