After upgrade to Spotlight 5.0 found out that Explain plan window is missing dependent object statistics; In Spotlight all previous releases, starting from Instance monitor, you can see statistics on object from any line in explain plan, by clicking on this line; in detail window, it shows dependent table, with its indexes, together with statistics. Is this functionality missing in 5.0 of Spotlight.
FROM RELEASE NOTES:
Please make sure you hit refresh (F5) , it will not display automatically.
SQL Text- the full text of the SQL statement being executed. Right-click the SQL Text control to display a shortcut menu. From the menu, you can:
Choose Explain Plan to display the Explain Plan window.
Choose SQL Optimizer (or SQL Tuning) to display the SQL Optimizer (SQL Tuning) window.
Choose Predictive Diagnostics to predict SQL performance via Predictive Diagnostics (if available).
Choose Format SQL to display the SQL statement in the text box in a more readable form.
You can also use the launch buttons above the SQL Text control to access the same information. (These buttons appear only if the relevant application is available.)
Click the Explain Plan button to explain the SQL statement via the Explain Plan window.
Click the SQL Optimizer button to display context-sensitive tuning advice for SQL statements via SQL Optimizer or SQL Tuning.
Click the Predictive Diagnostics button to predict SQL performance via Predictive Diagnostics.
To view more information about the SQL statement:
Double-click a row in the Top SQL table to open the expanded SQL Details page for the statement.
Click the SQL Details tab to view the SQL Details sub-page for the statement.
Click the SQL Time Breakdown tab to view breakdown statistics for the SQL statement.
Click the SQL Plan tab to view the execution plan for the SQL statement.
Click Full screen to view an expanded set of statistics for the SQL statement
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center