The Session SQL page shows the SQL in all open cursors for the session. From this page you can use the Explain Plan to explain the SQL, or SQL Optimizer (if installed) to provide context-sensitive tuning advice for SQL statements.
To open the Session SQL page
Select the Spotlight on Oracle connection in the Spotlight Browser.
Click Top Sessions Page.
Note: Alternatively, you can view session SQL for top sessions by I/O Time on the IO Drilldown | Session SQL Page.
To display session information for a SQL statement
Do one of the following:
Action |
Description |
---|---|
Click Explain SQL |
Explain the SQL via the Explain Plan. Tools | Explain Plan |
Click SQL Optimizer |
Display context-sensitive tuning advice for SQL statements via SQL Optimizer (or SQL Tuning). Tools | SQL Optimizer Note: For more information on SQL Optimizer, see the SQL Optimizer documentation. |
Click Show in Top SQL |
Open the SQL in the TOP SQL Drilldown | Top SQL Page |
Right-click the SQL Text window and select Format SQL. | Display the SQL statement in a more readable form. |
Note: If the SQL cannot be explained, the Explain Plan and SQL Optimizer actions may be unavailable.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 使用条款 隐私 Cookie Preference Center