Why does the report I generate through a call to dbms_sqltune.report_tuning_task not include information about every SQL statement in the STS that was tuned?
This can happen either because you specified an object_id or result_limit argument to the function, or because SQL tuning ran out of time when it was tuning the STS. To remedy this, re-tune the STS, this time passing a bigger ‘time_limit’ argument to dbms_sqltune.create_tuning_task. Tuning tasks default to a time limit of 1800 seconds (30 minutes), which may not be enough for some tuning sets.
Related Questions
- Why does the report I generate through a call to dbms_sqltune.report_tuning_task not include information about every SQL statement in the STS that was tuned?
- Which is better or faster for crystal report performance - SQL commands or stored procedures ?
- How can I change a report or chart RowSource SQL at run-time (dynamically)?
