Skip to Main Content

On Autom. SQL Tuning result report/details page, what does 'weekly benefit' mean?

SebinoDec 12 2022

Hello,
Once in SQL advisor (and as the docs.oracle.com/en/database/oracle/oracle-database/19/tdppt/tuning-sql-statements.html page shows it too), once you've clicked View Report of the 'Automatic SQL Tuning Result Summary' page you end up with a table with columns SQL Text - Parsing schema - SQL ID - Weekly DB time benefit(sec) - Per-execution % benefit...
What does this 'Weekly DB time benefit' mean? On the example page here above, does that mean that if I implemented the recommendation suggested for SQL ID fudg5z56q642p I would gain 60.38 secs of time per week is that right?
And someone has an idea of how the next-column 'Per-exec. % benefit' ratio is calculated?
Thanks a lot.
Regards,
Sebino

Comments
Post Details
Added on Dec 12 2022
0 comments
22 views