To get SQL Trace



To get SQL Trace

. Set profile FND: Diagnostics to Yes at user level.
. Login as the above user
. Click on Diagnostics icon(Home Page).
. Select 'Set Trace Level' and click Go
. Select the desired trace level (binds and waits) and click Save
. Run Depreciation
. Click Diagnostics icon
. Select 'Set Trace Level' and “No Trace”, click Go
. Take note of the Trace ID numbers on the left side of the page (Typically there will be multiple file numbers; these Trace ID number will be part of the raw trace file name)
. Find the trace files using command like below. See Note 290614.1 to find the location of the trace files which depends on the rdbms version.

$ ls -lt *<file number>*

--on database server

Execute tkprof in the trace files with sort options exeela, fchela, prsela as it sorts sql statements by execution, fetch and parse time. This will list them first, syntax is:

$ tkprof explain=apps/ <pwd> sort='(prsela,exeela,fchela)'

- OR -

$ tkprof <filename> output=/<path>/<filename.prf> explain=apps/<pwd> sort='(exeela, fchela,prsela)'