Search

Running EBS concurrent requests

select fpro.os_process_id pid,

fcr.request_id,

to_char(fcr.actual_start_date, 'DD/MM/YYYY HH24:MI:SS') start_date,

fcp.user_concurrent_program_name program_name,

fcq.concurrent_queue_name queue_name,

f.user_name

from fnd_user f,

fnd_concurrent_queues fcq,

fnd_concurrent_requests fcr,

fnd_concurrent_programs_tl fcp,

fnd_concurrent_processes fpro

where fcr.phase_code = 'R'

and fcr.status_code = 'R'

and fcr.controlling_manager = fpro.concurrent_process_id

and(fcq.concurrent_queue_id = fpro.concurrent_queue_id

and fcq.application_id = fpro.queue_application_id )

and(fcr.concurrent_program_id = fcp.concurrent_program_id

and fcr.program_application_id = fcp.application_id )

and fcr.requested_by = f.user_id

and fcp.language = 'US';


2 views0 comments

Recent Posts

See All

After logon trigger - trace user sessions

-- Activate trace for sessions using after logon database trigger -- -- Tables: -- -- SYS.XX_LOGIN_TRACE_CONDITION - add here the conditions for activating trace -- SYS.XX_LOGIN_TRACED_SESSIONS - con

INCLUDE parameter of expdp

-- Export all public database links expdp user/password full=y \ include=db_link:"in (select db_link from dba_db_links where owner = 'PUBLIC')" -- Export one table expdp user/password include=table:"i

Multiplexing Redo Log and Control files

-- List redo log files select group#, member from v$logfile order by group#, member; -- Check redo log file status select group#, members, status from v$log; -- Adding redo log file to a group alter d