Tuesday, November 2, 2021

Sessions

select count(1) FROM DBA_HIST_ACTIVE_SESS_HISTORY where to_char(sample_time,'DD-MON-YYYY HH:MI:SS') >= '30-OCT-2021 09:00:00' and to_char(sample_time,'DD-MON-YYYY HH:MI:SS') <= '30-OCT-2021 22:00:00'
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

SQL executions based on AWR

SQL exection per day SELECT TO_CHAR(s.BEGIN_INTERVAL_TIME, 'YYYY-MM-DD') AS execution_date, ss.SQL_ID, SUM(ss.EXECUT...