Thanks for the extensive write up.
Could you mention "Important Licensing Note: The AWR-based queries above require Oracle's Diagnostic and Tuning Pack license. If you don't have this license, stick with the v$sqlstats approach or use Statspack as a free alternative." a bit earlier in the article?
dba_hist_sqlstat is already used in "Indexing: The Art of Strategic Access Paths"