Oracle Database 2 Day DBA 11g Release- P12:Oracle Database 2 Day DBA is a database administration quick start guide that teaches you how to perform day-to-day database administrative tasks. The goal of this guide is to help you understand the concepts behind Oracle Database. It teaches you how to perform all common administrative tasks needed to keep the database operational, including how to perform basic troubleshooting and performance monitoring activities. | Using Advisors to Optimize Database Performance The Schedule SQL Tuning Advisor page appears. 5. Under SQL Tuning Advisor Data Source Links click Top Activity. The Top Activity page appears. This page has a timeline graph showing the database activity based on the active sessions over the last hour. 6. Optional Expand the timeline by selecting Historical from the View Data list at the upper right-hand side of the page. 7. Select an interval to analyze by clicking the bar under the timeline graph. The Top SQL and Top Sessions tables show the activity within the selected period. 8. In the Top SQL section select one or more SQL statements and then click the Go button next to Schedule SQL Tuning Advisor. The Schedule SQL Tuning Advisor page returns indicating the statements that are to be tuned. 9. Enter a task name and description select the scope for the analysis Comprehensive or Limited and select a start time for the analysis task. 10. Click OK. A Processing page appears. When the task is complete the SQL Tuning Results page appears showing a summary of recommendations for each SQL statement analyzed. The recommendation can include one or more of the following Accept the generated SQL profile. Gather optimizer statistics on objects with stale or no statistics. Rewrite a query for better performance. Create an index to offer alternate faster access paths to the query optimizer. 11. To view recommendations for a specified SQL statement select a statement from the list of recommendations and then click View. The Recommendations for SQL ID page appears showing one or more recommendations for the statement. Monitoring and Tuning the Database 10-25 Using Advisors to Optimize Database Performance 12. Optional Select a recommendation and then click Implement. The Implement Recommendation page appears. Depending on the type of recommendation select options and then click OK to proceed. See Also About the SQL Advisors on page 10-18 About the Automatic SQL Tuning Advisor on .
