ORACLE10G's EM tool optimizes SQL functionality

Source: Internet
Author: User

Work arrangement, need to do SQL optimization in oracle10g, know that Oracle's EM tool can be optimized for system, so the following operation.

Baidu Search to the following link, this would like to follow the steps of SQL optimization:

http://blog.csdn.net/binyao02123202/article/details/19323381

But after entering, found that the appeal blog content Oracle 11g, I was not found on 10g, 10g below are as follows:

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/7E/F3/wKioL1cN_8LQl09mAAAbxq6Lt5c564.png "title=" 1.png " alt= "Wkiol1cn_8lql09maaabxq6lt5c564.png"/> For this sense 10g's EM tool is not able to do SQL optimization, but after a successful morning's success, found a 10g approach to SQL optimization.

The steps are as follows:

1: Enter the EM management tool, in the Guide center below----SQL Optimization guide----top-level activities.

2: Can be seen as follows:

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/7E/F3/wKioL1cOAIXCNET8AABRnvGLqU8167.png "title=" 2.png " alt= "Wkiol1coaixcnet8aabrnvglqu8167.png"/>

3: Go to Plsqldev to execute once you need to optimize the SQL, and then wait here for a few minutes, refresh, you will see a new sql/id, mouse up, hover to see if some SQL is the SQL you execute.

4: Tick The SQL activity you executed, click on the Scheduling SQL Optimization guide and go to the optimization interface.

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/7E/F6/wKiom1cOAFeyTcnlAACDA_lE2Dg338.png "title=" 3.png " alt= "Wkiom1coafeytcnlaacda_le2dg338.png"/>5: Default settings, click OK.

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/7E/F3/wKioL1cOAUmSbBLvAABHWEmaEjM609.png "title=" 4.png " alt= "Wkiol1coaumsbblvaabhwemaejm609.png"/> Best display system to give the optimization hints, if the new index can be implemented, you can click on the implementation, the system automatically to you to build optimized indexes, and other tips for reference only.


Note: The EM system optimization is only an Oracle-brought auxiliary tool, specifically optimized or you have to study SQL.

This article is from the "butcher36" blog, make sure to keep this source http://butcher36.blog.51cto.com/9315484/1763475

ORACLE10G's EM tool optimizes SQL functionality

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.