active session history
-- 특정 시간 active session 학인 select SAMPLE_ID, SAMPLE_TIME, SESSION_ID, SESSION_SERIAL#, SESSION_TYPE, USER_ID, SQL_ID, SQL_OPNAME, SQL_EXEC_START, PROGRAM, MODULE, MACHINE from v$active_session_history where SAMPLE_TIME >= to_date('2022-01-30 11:59:00','YYYY-MM-DD HH24:MI:SS') and SAMPLE_TIME
2022. 1. 30.