Find database session ID, module for a running concurrent request — oracle-mosc

Core Concurrent Processing - EBS (MOSC)

MOSC Banner

Find database session ID, module for a running concurrent request

edited Nov 18, 2019 3:08PM in Core Concurrent Processing - EBS (MOSC) 2 commentsAnswered

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"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center