Concurrent program SQL statement currently running in background
Oracle apps current sql query
oracle sql running in session
oracle sql running in background
Step1 : Run the below query , this will list all the programs that currently running in Application. Take the SID and use it in the second query.
SELECT f.user_name,
a.request_id "Req Id",
a.concurrent_program_id "Prg Id",
a.RESPONSIBILITY_ID Responsibility,
a.phase_code,
a.status_code,
b.os_process_id "OS",
vs.sid,
vs.serial# "Serial#",
vp.spid,
TO_CHAR (request_date, 'DD-MON-YY hh24:mi:ss') request_date,
(NVL (a.actual_completion_date, SYSDATE) - a.actual_start_date) * 1440
"Time",
c.concurrent_program_name || ' - ' || c2.user_concurrent_program_name
"Program"
FROM APPLSYS.fnd_Concurrent_requests a,
APPLSYS.fnd_concurrent_processes b,
applsys.fnd_concurrent_queues q,
APPLSYS.fnd_concurrent_programs_tl c2,
APPLSYS.fnd_concurrent_programs c,
APPLSYS.fnd_user f,
v$session vs,
v$process vp
WHERE a.controlling_manager = b.concurrent_process_id
AND a.concurrent_program_id = c.concurrent_program_id
AND a.program_application_id = c.application_id
AND c2.concurrent_program_id = c.concurrent_program_id
AND c2.application_id = c.application_id
AND a.phase_code IN ('I',
'P',
'R',
'T')
AND a.requested_by = f.user_id
AND b.queue_application_id = q.application_id
AND b.concurrent_queue_id = q.concurrent_queue_id
AND c2.LANGUAGE = 'US'
AND a.oracle_process_id = vp.spid
AND a.request_id = '<Provide concurrentyour request ID>'
AND vs.paddr = vp.addr
ORDER BY 9
Step 2 : Get SID from step 1 and Keep on executing this query in SQL.
This query will show the currently running SQL in the DB, as your concurrent is submitted and running.
SELECT sql_text
FROM v$sqltext t, v$session s
WHERE t.ADDRESS = s.SQL_ADDRESS
AND t.HASH_VALUE = s.SQL_HASH_VALUE
AND s.sid = 144 -- Get this value from step 1
ORDER BY PIECE
Related posts:
- Register a test concurrent program from backend in Oracle EBS
- Supervisor Hierarchy and Approval Limits in Oracle EBS R12
- Query to find vacation rules in Oracle R12
- View java class source in oracle database
- Load Java source code in oracle database
- Query to find all APIs of Oracle Apps modules
- OAF customizations queries
- Oracle apps list of concurrent programs in a Request Set
- Query to get Organization Hierarchy in Oracle apps
- Oracle apps query to find incompatible programs blocking a concurrent request
- Form function attached to which responsibility and user
- Query to find the responsibility attached to user in oracle apps
- How to enable debug log in Oracle apps EBS
- How to add AME role and responsibility to user
- Oracle form attached to which responsibility
- SQL query to get MIME type for file extension
- Query to get concurrent program and executable details
- Query to get responsibility level profile option values
- Query to validate migration of XML/BI Publisher Template and Data Definition
- Query to get details of XML/BI Publisher Template and Data Definition
- Query to get Site level and Organization level Profile Option Value
- PL-SQL code to reset application user password
- PL-SQL Procedure to send email with attachment
- PL-SQL to delete Concurrent Program and Executable
- Query to get the details of the lock in the database
- PL-SQL code to delete XML/BI Publisher template and Data Definition
- Query to find Form Personalization
- Query to find profile option values
- Query to get details of concurrent program parameters
- PL-SQL Code to find Menu Hierarchy of a responsibility
- Query to find details of Flex value sets
- Query to find concurrent program Responsibility and Request Group
- Concurrent program SQL statement currently running in background
- Query to find scheduled concurrent programs
- Query to kill database session for a concurrent request
- Query to get DFF (Descriptive Flex Field) Details