Find database session ID, module for a running concurrent request
I used this script to check currently running jobs. Database Session ID and Module are not right. Anyone has a script to display (reqID, username, database session ID, module name, programe name, running time, ...) to share please. Thank you in advance!
==
1 SELECT SUBSTR(LTRIM(req.request_id),1,15) concreq,
2 fu.user_name "Username",
3 sw.sid sid,
4 vsess.serial# serial#,
5 nvl2(sysdate,(to_char(floor((sysdate-actual_start_date)*24))||' hrs '||
6 to_char(round (((sysdate-actual_start_date)*60*24),0)- (floor((sysdate-actual_start_date)*24)*60)) ||' mins'),null)time,
7 SUBSTR(proc.os_process_id,1,15) SPID,
8 vsess.sql_hash_value,
9 vsess.module,
10 fcp.USER_CONCURRENT_PROGRAM_NAME "Program_Name"