I'd like to know whether anyone has any suggestions for the SQL Performance screen in Spotlight on Oracle Xpert version 5.0.
In particular:
- Do you typically need to alter the default settings of the SQL Statement Trend Analysis Wizard?
If so, would you want to be able to save the wizard's settings so that they can be loaded/restored the next time you use Spotlight?
- Would you want to be able to save and restore the contents of the SQL Performance screen so that you can process the listed SQL statements in an ad hoc manner over time?
That is, to be able to leave the SQL Performance screen without losing your work. This implies you'd want to be able to categorize each SQL statement in the screen's grid so that you know whether you've already processed/inspected the SQL statement.