SELECT SNAP_ID ,
DBID ,
INSTANCE_NUMBER ,
SAMPLE_ID ,
to_char(SAMPLE_TIME,'DD-MON-YYYY HH24:MI:SS') ,
SESSION_ID ,
SESSION_SERIAL# ,
USER_ID ,
SQL_ID ,
SQL_CHILD_NUMBER ,
SQL_PLAN_HASH_VALUE ,
FORCE_MATCHING_SIGNATURE ,
SQL_OPCODE ,
PLSQL_ENTRY_OBJECT_ID ,
PLSQL_ENTRY_SUBPROGRAM_ID ,
PLSQL_OBJECT_ID ,
PLSQL_SUBPROGRAM_ID ,
SERVICE_HASH ,
SESSION_TYPE ,
SESSION_STATE ,
QC_SESSION_ID ,
QC_INSTANCE_ID ,
BLOCKING_SESSION ,
BLOCKING_SESSION_STATUS ,
BLOCKING_SESSION_SERIAL# ,
EVENT ,
EVENT_ID ,
SEQ# ,
P1TEXT ,
P1 ,
P2TEXT ,
P2 ,
P3TEXT ,
P3 ,
WAIT_CLASS ,
WAIT_CLASS_ID ,
WAIT_TIME ,
TIME_WAITED ,
CURRENT_OBJ# ,
CURRENT_FILE# ,
CURRENT_BLOCK# ,
PROGRAM ,
MODULE ,
ACTION ,
CLIENT_ID ,
FLAGS
FROM dba_hist_active_sess_history WHERE sample_time BETWEEN TO_DATE('14-AUG-2024 16:00','DD-MON-YYYY HH24:MI')
AND TO_DATE('14-AUG-2024 20:00','DD-MON-YYYY HH24:MI')
and client_id='RAM';
SELECT A.REQUEST_ID, D.SID, D.SERIAL# , C.SPID
FROM APPS.FND_CONCURRENT_REQUESTS A,
APPS.FND_CONCURRENT_PROCESSES B,
V$PROCESS C,
V$SESSION D
WHERE A.CONTROLLING_MANAGER = B.CONCURRENT_PROCESS_ID
AND C.PID = B.ORACLE_PROCESS_ID
AND B.SESSION_ID=D.AUDSID
AND A.REQUEST_ID = 129634975
AND A.PHASE_CODE = 'R';
select session_id, session_serial#, module, sql_id, sql_plan_hash_value, count(*)*10 runtime_sec, min(sample_time), max(sample_time)
from dba_hist_active_sess_history
where 1=1
and (session_id, session_serial#) in ((129615845,10613))
group by session_id, session_serial#, sql_id, sql_plan_hash_value, module
order by count(*)*10 desc
