Basic SQL tuning tools
SQL Analyze utility
SQL Analyze utility
- With the Oracle Enterprise Manager open, click the Oracle SQL Analyzer button.
- Read the opening screen, and click OK.
- Now we are ready to begin. Select the bottommost database under the Databases folder.
- Select Top SQL from the mon1 database.
- The TopSQL Options box will allow you to control the number of disk reads as well as apply various filters. Click OK.
- Choose our database to view the init.ora parameters for SQL values. Select select/*+rule*/ a.db_name.
- Click the SQL Text tab to view the full SQL text.
- Place your cursor anywhere in the SQL text field and click to highlight the text.
- In an actual Oracle environment, you would press Ctrl+C to copy this text and Ctrl+N to move to a new screen. For the purposes of this simulation, press Enter to move to a new SQL screen.
- For the purposes of this simulation, place your cursor in the SQL statement window and hit Enter to paste your SQL text. You would normally accomplish this by pressing Ctrl+V.
- Typically, you would press F9 to see the rule-based explain plan, but for the purposes of this simulation press Enter.
