Queries Arsenel for Oracle Apps DBA - Part 3

Queries Arsenel for Oracle Apps DBA - Part 3

**********************************************************

CONCURRENT MANAGER

**********************************************************

--- Script to display status of all concurrent managers

select distinct Concurrent_Process_Id CpId, PID Opid,

Os_Process_ID Osid, Q.Concurrent_Queue_Name Manager,

P.process_status_code Status,

To_Char(P.Process_Start_Date, 'MM-DD-YYYY HH:MI:SSAM') Started_At

from Fnd_Concurrent_Processes P, Fnd_Concurrent_Queues Q, FND_V$Process

where Q.Application_Id = Queue_Application_ID

and Q.Concurrent_Queue_ID = P.Concurrent_Queue_ID

and Spid = Os_Process_ID

and Process_Status_Code not in ('K','S')

order by Concurrent_Process_ID, Os_Process_Id, Q.Concurrent_Queue_Name;



-- Check which all concurrent manager is down

select * from fnd_concurrent_queues where max_processes != running_processes;



--Find Conc Manager designated to run your Conc request



SELECT user_concurrent_program_name, user_concurrent_queue_name

FROM apps.fnd_concurrent_programs_tl cp, apps.fnd_concurrent_queue_content cqc,

apps.fnd_concurrent_queues_tl cq WHERE cqc.type_application_id(+) = cp.application_id

AND cqc.type_id(+) = cp.concurrent_program_id AND cqc.type_code(+) = 'P'

AND cqc.include_flag(+) = 'I' AND cp.LANGUAGE = 'US'

AND cp.user_concurrent_program_name = 'Credit Card Outstanding Transactions Management (Details)'

AND NVL (cqc.concurrent_queue_id, 0) = cq.concurrent_queue_id

AND NVL (cqc.queue_application_id, 0) = cq.application_id AND cq.LANGUAGE = 'US';



-- After request has been run:-

Select

'The '

Concurrent_Queue_Name



' concurrent manager ran your request from',

to_char(Actual_Start_date, ' MON-DD-YY HH:MI:SS AM')

' - to - '



to_char(Actual_COMPLETION_date, 'MON-DD-YY HH:MI:SS AM'),

'The '

Concurrent_Queue_Name



' concurrent manager log file is '

P.Logfile_Name,

'Request log file is '

R.Logfile_Name

From Fnd_Concurrent_Queues Q,

Fnd_Concurrent_requests R,

Fnd_Concurrent_Processes P

Where

(P.Concurrent_Queue_ID = Q.Concurrent_Queue_ID And

Queue_Application_ID = Q.Application_ID )

And R.Controlling_Manager = P.Concurrent_Process_ID

And R.Phase_Code = 'C'

And Request_ID = &Request_ID