This content has been marked as final. Show 7 replies
user3308982 wrote:How do I ask a question on the forums?
We are using AIX 5.3 OS and Database version 22.214.171.124
i am unable to generate trace file
SQL and PL/SQL FAQ
I can generate trace file by issuing SQL below
ALTER SESSION SET SQL_TRACE=TURE;
Status Level: Newbie
Registered: Apr 5, 2009
Total Posts: 293
Total Questions: 135 (118 unresolved)
why do you waste time here when you rarely get answer to your questions
'My car is broke, please fix my car'
This is not a chatroom, and we can not see what you do.
- how are you generating the trace file
- Where are you looking for the trace file.
Senior Oracle DBA
we are trying to generate trace from Application (Concurrent Program) and followed doc id -How To Trace a Concurrent Request And Generate TKPROF File [ID 453527.1].
and at database level i changed parameter value to sql_trace = true and bounced DB still it is not generating file
Below query showing location for tace
SELECT 'Request id: '||request_id ,
'Trace id: '||oracle_Process_id,
'Trace Flag: '||req.enable_trace,
'Prog. Name: '||prog.user_concurrent_program_name,
'File Name: '||execname.execution_file_name|| execname.subroutine_name ,
'Status : '||decode(phase_code,'R','Running')
'SID Serial: '||ses.sid||','|| ses.serial#,
'Module : '||ses.module
from fnd_concurrent_requests req, v$session ses, v$process proc,
v$parameter dest, v$parameter dbnm, fnd_concurrent_programs_vl prog,
where req.request_id = &request
and proc.addr = ses.paddr(+)
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_application_id = execname.application_id
i tried to search location from above query but unfortunately i didn't find trace file.
I would try this at the session level.
How to Create a SQL Trace from Another Session [ID 100883.1]
ALTER SESSION SET sql_trace = true;
How To Collect 10046 Trace (SQL_TRACE) Diagnostics for Performance Issues [ID 376442.1]
How To Enable/Disable SQL Tracing Without Wasting Disk Space Or Losing The Trace File [ID 404833.1]
How To Find Session Details and Trace Filename Using SELECTs [ID 377828.1]
Init.ora Parameter "SQL_TRACE" Reference Note [ID 30820.1]
Edited by: mseberg on Aug 25, 2012 10:46 AM
Moving this thread to the EBS forums
Pl post details of database, OS and EBS versions.
What output does this query return ?
where req.request_id = &requestAre you passing the correct request_id to the query? If not, please do so and you should get an output of tracing was enabled as per the doc.