Tuesday, May 7, 2019

Oracle Performance Tuning


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