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 wait events
http://gavinsoorma.com/2012/11/ash-and-awr-performance-tuning-scripts/