How to Analyze the Performance History of a SQL Statement as Recorded in AWR Using Simple SQL (Doc ID 1580764.1)
http://www.nocoug.org/download/2008-08/a-tour-of-the-awr-tables.nocoug-Aug-21-2008.abercrombie.html
https://www.realdbamagic.com/script-finding-top-n-queries-user-awr/
https://blog.pythian.com/mining-the-awr-to-identify-performance-trends/
https://karlarao.wordpress.com/scripts-resources/
https://github.com/tanelpoder/tpt-oracle
https://blog.tanelpoder.com/posts/oracle-sql-monitoring-advanced-ash-usage-hacking-session/
https://blog.tanelpoder.com/2018/05/18/my-performance-troubleshooting-scripts-tpt-for-oracle-are-now-in-github-and-open-sourced/
https://github.com/tanelpoder/tpt-oracle
https://www.youtube.com/TanelPoder
EXTREME DETAILS ABOUT A SQL
https://mjsoracleblog.wordpress.com/2013/02/19/my-oracle_performance-github-repository/
https://github.com/khailey/ashmasters
http://bdrouvot.wordpress.com/real_time/ => script to get real time I/O