Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

How To Enable Tracing ( Request Running/Normal)

Posted on May 11th, 2010 by Sanjit Anand ||Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

dgreybarrow Enable Tracing On Program Level is not recommended by Oracle. there is way to do

System Administrator Responsibility

Navigation: Concurrent -> Program -> Define

Click the “Enable Trace” button

TRACE

Fig 1

Please take a note, once it enabled, this generates trace for all the request submitted by all end- users. Hence this could generate lots of trace files which is an additional overhead and degrade performance of the application.

dgreybarrowEnable Tracing On Request Level , this is Recommended way to do:

Steps are :

  • Responsibility: System Administrator
  • Navigate: Profiles > System
  • Query Profile Option Concurrent: Allow Debugging
  • Set profile to Yes
  • Logon to the Responsibility that runs the Concurrent Program
  • In the Submit Request Screen click on Debug Options (B) [ see fig 2]
  • Select the Checkbox for SQL Trace and select desired Trace level.[ see fig 3]
  • Submit the Request.

TRACE1

Fig 2

TRACE2

Fig 3

Once you have obtained the Raw trace file you need to format the file using TKPROF :

tkprof raw_trace_file.trc output_file explain=apps/<passwd> \sort=(exeela,fchela, prsela)

If you do not know the path for those directories, you can run a command like the following query in SQL :

select name, value from v$parameter where name = ‘user_dump_dest’;

Related Posts

Posted in AOL | No Comments »Email This Post Email This Post |

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.