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 session
— 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(*))…
This error generally occurs when you are trying to trace a user session using the DBMS_SUPPORT package. But this package isn’t…