Below Query is used for fetching the Trace File location the server:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
SELECT 'Request id: '
||request_id,
'Trace id: '
||oracle_process_id,
'Trace Flag: '
||req.enable_trace,
'Trace Name: '
||dest.value
||'/'
||LOWER(dbnm.value)
||'_ora_'
||oracle_process_id
||'.trc' "Trace File Name",
'Prog. Name: '
||prog.user_concurrent_program_name "Conc Prog. Name",
'File Name: '
||execname.execution_file_name
|| execname.subroutine_name "File Name",
'Status : '
||DECODE(phase_code, 'R', 'Running')
||'-'
||DECODE(status_code, 'R', 'Normal') "Status",
'SID Serial: '
||ses.sid
||','
|| ses.serial#,
'Module : '
||ses.MODULE "SID Serial"
FROM fnd_concurrent_requests req,
v$session ses,
v$process proc,
v$parameter dest,
v$parameter dbnm,
fnd_concurrent_programs_vl prog,
fnd_executables execname
WHERE req.request_id = 72699785
AND req.oracle_process_id = proc.spid(+)
AND proc.addr = ses.paddr(+)
AND dest.name = 'user_dump_dest'
AND dbnm.name = 'db_name'
AND req.concurrent_program_id = prog.concurrent_program_id
AND req.program_application_id = prog.application_id
AND prog.application_id = execname.application_id
AND prog.executable_id = execname.executable_id;
|
0 comments