Tag session

ASH Script for Finding out Top Wait Events in Oracle

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;…

Count number of sessions oracle

— Count number of sessions oracle for 7 days, Provided you keep data that long — [sourcecode language=”sql”] select to_char(BEGIN_INTERVAL_TIME,’HH24′), ROUND(SUM(CURRENT_UTILIZATION)/COUNT(*))…