Core Concurrent Processing - EBS (MOSC)

MOSC Banner

How to find the concurrent request id from the sql_id?

Hi all:

We have some performance issue. We have identified three troubled sql id. I want to find out which concurrent request do these sql id belongs to. I found an oracle notes and point to below query; however, since the concurrent request is not currently running and there is no active session, thus the below query returns no rows. Is there another way to find the concurrent request from sql_id of an already completed concurrent request?

SELECT fcr.request_id,
fcp.user_concurrent_program_name,
vsq.sql_text,
vsq.SQL_ID
FROM fnd_concurrent_requests fcr,
v$process vp,

Howdy, Stranger!

Log In

To view full details, sign in.

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