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