prompt ************************************ prompt **** ASH OVERALL WAIT PROFILE prompt ************************************ set lines 999 SELECT MIN(sample_time) min_ash_available,sysdate-MIN(sample_time) available duration FROM v$active_session_history;…
Tag ASH
http://gavinsoorma.com/2012/11/ash-and-awr-performance-tuning-scripts/
Even when sessions are inactive they can be executing SQL’s in the background. You have to identify the SQL’s which…