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