Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdppt\tdppt_sqlopt021.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>Implementing the SQL Access Advisor Recommendations</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" /> <meta name="date" content="2009-05-27T15:13:3Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Implementing the SQL Access Advisor Recommendations" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E10822-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="tdppt_sqlopt020.htm" title="Previous" 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="tdppt_sqlopt020.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> </tr> </table> <p><a id="CIHEAGDG" name="CIHEAGDG"></a><a id="TDPPT192" name="TDPPT192"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1>Implementing the SQL Access Advisor Recommendations</h1> <a name="BEGIN" id="BEGIN"></a> <p>A SQL Access Advisor recommendation can range from a simple suggestion to a complex solution that requires partitioning a set of existing base tables and implementing a set of database objects such as indexes, materialized views, and materialized view logs. You can select the recommendations for implementation and schedule when the job should be executed.</p> <div class="helpinfonote"> <p><span class="bold">Tip: </span>Before implementing the SQL Access Advisor recommendations, review them for cost benefits to determine which ones, if any, should be implemented. For more information, see <a href="tdppt_sqlopt016.htm#CHDFDJEH">"Reviewing the SQL Access Advisor Recommendations"</a>.</p> </div> <p class="orderedlisttitle">To implement the SQL Access Advisor recommendations<a id="sthref340" name="sthref340"></a>: </p> <ol> <li> <p>On the Results for Tasks page, click <span class="bold">Recommendations</span>.</p> <p>The Recommendations subpage appears.</p> </li> <li> <p>Under Select Recommendations for Implementation, select the recommendation you want to implement and then click <span class="bold">Schedule Implementation</span>.</p> <p>The Schedule Implementation page appears.</p> </li> <li> <p>In the <span class="bold">Job Name</span> field, enter a name for the job if you do not want to use the system-generated job name.</p> </li> <li> <p>Determine whether or not the implementation job should stop if an error is encountered. Do one of the following:</p> <ul> <li> <p>To stop processing if an error occurs, select <span class="bold">Stop on Error</span>.</p> </li> <li> <p>To continue processing even if an error occurs, deselect <span class="bold">Stop on Error</span>.</p> </li> </ul> </li> <li> <p>Under Scheduling Options, in the Schedule Type list, select a schedule type for the task and a maintenance window in which the task should run. Do one of the following:</p> <ul> <li> <p>Click <span class="bold">Standard</span>.</p> <p>This schedule type enables you to select a repeating interval and start time for the task. Complete the following steps:</p> <ul> <li> <p>Enter your time zone code in the <span class="bold">Time Zone</span> field or click the search icon to locate the code for your area.</p> </li> <li> <p>In the Repeat list, select <span class="bold">Do Not Repeat</span> to perform the task only once, or select a unit of time and enter the number of units in the <span class="bold">Interval</span> field.</p> </li> <li> <p>Under Start, 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 <span class="bold">Date</span> and <span class="bold">Time</span> fields.</p> </li> </ul> </li> <li> <p>Click <span class="bold">Use predefined schedule</span>.</p> <p>This schedule type enables you to select an existing schedule. Do one of the following:</p> <ul> <li> <p>In the <span class="bold">Schedule</span> field, enter the name of the schedule to be used for the task.</p> </li> <li> <p>To search for a schedule, click the search icon.</p> <p>The Search and Select: Schedule dialog box appears.</p> <p>Select the desired schedule and click <span class="bold">Select</span>. The selected schedule now appears in the <span class="bold">Schedule</span> field.</p> </li> </ul> </li> <li> <p>Click <span class="bold">Standard using PL/SQL for repeated interval</span>.</p> <p>This schedule type enables you to select a repeating interval and an execution window for the task. Complete the following steps:</p> <ul> <li> <p>Enter your time zone code in the <span class="bold">Time Zone</span> field or click the search icon to locate the code for your area.</p> </li> <li> <p>Under Available to Start, 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 <span class="bold">Date</span> and <span class="bold">Time</span> fields.</p> </li> <li> <p>In the Repeat list, select <span class="bold">Do Not Repeat</span> to perform the task only once, or select a unit of time and enter the number of units in the <span class="bold">Interval</span> field.</p> </li> <li> <p>In the <span class="bold">Repeated Interval</span> field, enter a PL/SQL schedule expression, such as <code>SYSDATE+1</code>.</p> </li> <li> <p>Under Not Available After, select <span class="bold">No End Date</span> to indicate that there is no end date for the execution window, or <span class="bold">Specified End Date</span> to specify an end date using the <span class="bold">Date</span> and <span class="bold">Time</span> fields.</p> </li> </ul> </li> <li> <p>Click <span class="bold">Use predefined window</span>.</p> <p>This schedule type enables you to select an existing window. Select <span class="bold">Stop on Window Close</span> to stop the job when the window closes. Do one of the following:</p> <ul> <li> <p>In the <span class="bold">Window</span> field, enter the name of the window to be used for the task.</p> </li> <li> <p>To search for a window, click the search icon.</p> <p>The Search and Select: Window and Window Groups dialog box appears.</p> <p>Select the desired window and click <span class="bold">Select</span>. The selected window now appears in the <span class="bold">Schedule</span> field.</p> </li> </ul> </li> <li> <p>Click <span class="bold">Event</span>.</p> <p>Complete the following steps:</p> <ul> <li> <p>Enter your time zone code in the <span class="bold">Time Zone</span> field or click the search icon to locate the code for your area.</p> </li> <li> <p>Under Event Parameters, enter values in the <span class="bold">Queue Name</span> and <span class="bold">Condition</span> fields.</p> </li> <li> <p>Under Start, 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 <span class="bold">Date</span> and <span class="bold">Time</span> fields.</p> </li> <li> <p>Under Not Available After, select <span class="bold">No End Date</span> to indicate that there is no end date for the execution window, or <span class="bold">Specified End Date</span> to specify an end date using the <span class="bold">Date</span> and <span class="bold">Time</span> fields.</p> </li> </ul> </li> <li> <p>Click <span class="bold">Calendar</span>.</p> <p>Complete the following steps:</p> <ul> <li> <p>Enter your time zone code in the <span class="bold">Time Zone</span> field or click the search icon to locate the code for your area.</p> </li> <li> <p>Under Calendar Expression, enter a calendar expression.</p> </li> <li> <p>Under Start, 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 <span class="bold">Date</span> and <span class="bold">Time</span> fields.</p> </li> <li> <p>Under Not Available After, select <span class="bold">No End Date</span> to indicate that there is no end date for the execution window, or <span class="bold">Specified End Date</span> to specify an end date using the <span class="bold">Date</span> and <span class="bold">Time</span> fields.</p> </li> </ul> </li> </ul> </li> <li> <p>Optionally, click <span class="bold">Show SQL</span> to view the SQL text for the job.</p> </li> <li> <p>To submit the job, click <span class="bold">Submit</span>.</p> </li> <li> <p>Do one of the following, depending on whether the job is scheduled to start immediately or later:</p> <ul> <li> <p>If you submitted the job immediately, and if the Results for Task page is shown, then click the link in the <span class="bold">Scheduler Job</span> field to display the View Job page. Go to Step <a href="#CIHBDFBF">10</a>.</p> </li> <li> <p>If the job is scheduled to start at a later time, then proceed to Step <a href="#CHDDBFII">9</a>.</p> </li> </ul> </li> <li><a id="CHDDBFII" name="CHDDBFII"></a> <p>Complete the following steps:</p> <ol> <li> <p>On the Server page, under Oracle Scheduler, click <span class="bold">Jobs</span>.</p> <p>The Scheduler Jobs page appears.</p> </li> <li> <p>Select the implementation job and click <span class="bold">View Job Definition</span>.</p> <p>The View Job page for the selected job appears.</p> </li> </ol> </li> <li><a id="CIHBDFBF" name="CIHBDFBF"></a> <p>On the View Job page, under Operation Detail, check the status of the operation.</p> </li> <li> <p>Optionally, select the operation and click <span class="bold">View</span>.</p> <p>The Operation Detail page appears.</p> <p>This page contains information (such as start date and time, run duration, CPU time used, and session ID) that you can use when troubleshooting.</p> </li> <li> <p>Optionally, from the Database Home page, click <span class="bold">Schema</span>.</p> <p>The Schema subpage appears.On this page you can verify that the access structure recommended by SQL Access Advisor is created. Depending on the type of access structure that is created, you can display the access structure using the Indexes page, Materialized Views page, or the Materialized View Logs page.</p> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdppt_sqlopt.htm#BABGHCAE">Optimizing Data Access Paths</a></p> </div> </div> <!-- 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 © 2007, 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="tdppt_sqlopt020.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</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