Log on to oracle application
1. Go to System Administrator -> Concurrent -> Program -> Define.
2. Query the concurrent program for which you want to enable the trace.
3. Enable the check box “Enable Trace” and save it.
5. A SQL Trace will be Saved in the ../udump directory of the database server
Check out the following blog post for extracting the trace file from the database server