Use of the SQL Tuning Advisor

David Lozano Lucas's picture


One serious shortcoming of the SQL Tuning Advisor is that you can say "here is some SQL I'm thinking of running - please let me know if it can be improved". I think you can only ask it to look at SQL that has already been run. Granted, OEM is not really geared for developers, but it seems like such an obvious feature to be missing.

That's how OEM's SQL Advisor worked as of 10g...I haven't looked at 11g.