This post describe the SQL to fetch TOP SQL by Physical Reads from Historical per AWR Snapshots from history of Oracle database which can be used to analyse the performance of database while a defined time interval.
GenAI Practitioner, Data Engineer, Cloud Database Administrator
Showing posts with label AWR Top SQL using SQL. Show all posts
Showing posts with label AWR Top SQL using SQL. Show all posts
Top SQL by "Elapsed Time" reads from AWR history
This post describe the SQL to fetch "TOP SQL by Elapsed Time" from history of Oracle database which can be used to analyse the performance of database while a defined time interval.
Subscribe to:
Posts (Atom)