Used because the explain plan always says, 'Goal: Rule'. Tkprof?d output?s explain plan whether the rule or cost-based optimizer was Using the cost-based or the rule-based optimizer. Support, check to see if the SQL statement with the performance problem was That the code can be tuned to improve performance. Your knowledge and performance is still an issue, there is a strong possibility trc file to your $HOME directory, use the following syntax):ĪND rownum 99%, or if you have tuned the database to the best of If you do not have write permission in the directory where the raw trace is stored, copy the trace file to your $HOME directory, and then issue the following tkprof command from there. (Please note: You can only issue the tkprof command within a directory in which you have write permission. The above mentioned command sorts the SQL by placing the worst performing SQL statement at the top of the output file. Tkprof sys=no explain=apps/ sort='(prsela,exeela,fchela)' When troubleshooting a performance problem, it is best to issue the tkprof command at the UNIX prompt using the following syntax: A tkprof?d file has important information in readable format for the technical analyst to use for trouble-shooting purposes.

Now that you have a trace file, your analyst will need to see the tkprof?d output in order to analyze the problem. now you can retrieve precisely ora_.trc file.

=> enter PID found before it will give you SPID Where p.addr = s.paddr and p.pid = &your_pid under sqlplus, apps or system account, run : under System Administrator responsibility,Ĭolumn 'Oracle' (bloc 'SIGNON_AUDIT_VIEW', field 'PID') gives you the PID = A more precise method consists to find PID (Oracle Process Id) and determine corresponding SPID (Session Process Id): To retrieve your trace file you can try unix command : Select value from v$parameter where name='user_dump_dest' Directory where trace files reside is defined by variable USER_DUMP_DEST, if it is not set, execute sql command below from sqlplus (apps account):

Tkprof report