I m talking about EBS trace. Check EBS traces. Disabling tracing on EBS aplication.( forms, concurrent program , oaf etc)
Hi Erman,
thanks for the tips. I managed to get the spid from v$process using the serial# from 1 of the trace file of Daniel.
select v$session.sid, v$session.user#, v$process.spid from v$session,v$process where v$session.serial#=5651;
The result is shown below:
SID USER# USERNAME SPID
---------- ---------- ------------------------------ ------------------------
4227 173 APPS 57517
4227 173 APPS 42435
4227 173 APPS 42054
4227 173 APPS 42056
4227 173 APPS 42064
4227 173 APPS 42070
4227 173 APPS 42082
4227 173 APPS 42087
4227 173 APPS 42095
4227 173 APPS 42097
4227 173 APPS 42119
SID USER# USERNAME SPID
---------- ---------- ------------------------------ ------------------------
4227 173 APPS 42121
4227 173 APPS 42127
4227 173 APPS 42139
As shown above, there are many SPIDs. Which ones do I choose? or do I need to disable for all these sessions? will the command below disable the trace permanently?
If I proceed with EXECUTE DBMS_MONITOR.SESSION_TRACE_DISABLE(SPID,serial#)
Thanks,
Roshan
If you reply to this email, your message will be added to the discussion below:http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/trace-files-tp894p897.htmlTo start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML
| Free forum by Nabble |