Shulou(Shulou.com)06/01 Report--

SELECT REQUEST_ID

A.user_name

F.ACTUAL_START_DATE DATE_STARTED

DECODE (TRUNC (sysdate-ACTUAL_START_DATE)

0

NULL

TRUNC (sysdate-f.ACTUAL_START_DATE) | | 'Days' | |' +') |

TO_CHAR (TO_DATE (TRUNC (MOD (sysdate-f.ACTUAL_START_DATE, 1) * 86400)

'SSSSS')

'HH24:MI:SS') REQ_DURATION

S.SID

S.SERIAL#

S.status

P.SPID

S.MODULE

P.CONCURRENT_PROGRAM_NAME CONC_PROGRAM

ARGUMENT_TEXT

FROM applsys.fnd_concurrent_requests f

Applsys.fnd_user a

Applsys.fnd_concurrent_programs p

V$process p

V$session s

WHERE a.user_id (+) = f.REQUESTED_BY

AND f.CONCURRENT_PROGRAM_ID = p.CONCURRENT_PROGRAM_ID

AND TRUNC (f.ACTUAL_START_DATE) > TRUNC (SYSDATE-30)

-- AND request_id = 1491647

AND phase_code ='R'

AND s.paddr = p.addr

AND f.ORACLE_PROCESS_ID = p.spid

-- AND status_code ='C'

-- AND p.CONCURRENT_PROGRAM_NAME LIKE'% XLAACCUP%'

-- AND a.user_name like 'ACHASAPI'

-- AND ARGUMENT_TEXT LIKE'% TPA_Prov_IN%'

-- AND completion_text = 'Normal completion'

ORDER BY requested_start_date DESC

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.