trace files

[Roshan]

Oracle Database 11.2.0.3
 
Hello,
 
the system is generating too much trace files. The is a user on the system (Daniel). I have noticed there are lots of trace files of this username being generated. There is no warning or error in these log files. What can I do to minimize the volume of log files?

Capture.PNG
 
Thanks,
Regads
Roshan

[ErmanArslansOracleBlog]

He probably enabled forms trace.
check the relevant places for the disabling trace for that users.

Read these;
How To Trace From Form, Report, Program And Others In Oracle Applications [ID 130182.1]    
FAQ: Common Tracing Techniques within the Oracle Applications 11i/R12 [ID 296559.1]    

[ErmanArslansOracleBlog]

Also open one of the trace files, and try to understand which component is creating it. Understand whether it is a forms session trace, concurrent trace or whatever, and then take the corrective action(disabling the trace for that user )

[Roshan]

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

[ErmanArslansOracleBlog]

I m talking about EBS trace. Check EBS traces. Disabling tracing on EBS aplication.( forms, concurrent program , oaf etc)

14 Nis 2016 19:55 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

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.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

... [show rest of quote]

[Roshan]

Thanks. I got the doc (Doc ID 296559.1). Someone had enabled 'Initialization SQL Statement - Custom' profile option for the user Daniel..

[Roshan]

Hi,

there are some unwanted trace files that are still being. Trace has been disabled on all concurrent programs and forms. Is there a profile option that I need to disable? FND: Diagnostics is enabled at site level.

Thanks,
Regards

[ErmanArslansOracleBlog]

Is FND: Debug Log Enabled set to Yes?


Also check the values in user level, and other levels in addition to the site level.

[Roshan]

No. It is disabled at site level.

[ErmanArslansOracleBlog]

Send me one of those unwanted log files that are produced in your environment, and let me check what they are produced for.

Also try this query to check if you have any debug, trace or logging enabled in your env.

select  distinct
        a.application_short_name app_short,
        user_profile_option_name optname,
        decode(level_id,
        10001,'SITE',
        10002,'APP : '||a2.application_short_name,
        10003,'RESP: '||r.responsibility_key,
        10004,'USER: '||u.user_name,
        'Unknown') d_level,
        profile_option_value optval,
        v.last_update_date updated
from fnd_profile_options_vl o,
        fnd_profile_option_values v,
        fnd_application a,
        fnd_application a2,
        fnd_responsibility r,
        fnd_user u
where (
        upper(o.user_profile_option_name) like '%DEBUG%' or
        upper(o.user_profile_option_name) like '%TRACE%'
  --or upper(o.user_profile_option_name) like '%LOGG%'
        )
and a.application_id = v.application_id
and o.application_id = v.application_id
and o.profile_option_id = v.profile_option_id
-- Find the associate level for profile
and r.application_id (+) = v.level_value_application_id
and r.responsibility_id (+) = v.level_value
and a2.application_id (+) = v.level_value
and u.user_id (+) = v.level_value
and profile_option_value = 'Y'
order by 2,1,3,4;

[Roshan]

The unwanted trace files is due to the PO.
Capture.PNG
CaptureTrace.PNG
PROD_ora_6255_tracelevel12.trm

[ErmanArslansOracleBlog]

Check this document,

it explains how to obtain level12 trace (yours)
so you will do the opposite, you can use this document to check if it is enabled and then disable it.

How To Get Level 4 or Level 12 Trace And FND Debug Log For Concurrent Programs (Doc ID 726039.1)

[Roshan]

Thanks for the doc. How will I know the User who is submitting the process to trace?

I ran the query. The are some applications which have debug enabled. Do I need to disable all FND debug for these applications?

[Roshan]

Thanks. I got it from the developers. :)