Oracle Apps Tracing Session and Process

The purpose of this post is to bring together methods to active and retrieve trace when executing forms, reports, executables, and others involved in Oracle Applications v. 11.x. There are several notes on this subject; however they are not quite complete or clear for end users.

SCOPE & APPLICATION:Trace files are often needed for support purpose. Customers don't always know how to active trace and retrieve trace file.  

Currently running sessions in database

Often it requires keeping track of the currently running sessions and the Sql executed in the sessions. So here is the query by which you can find out.

SQL to identify the query which takes long time

Step1 :  Run the first query ,  this will list all the programs that currently running in Application. Take the SID and use it in the second query.