How to trace query in Oracle for performance tuning

1. check location for trace file SQL> show parameter user_dump_dest NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ user_dump_dest                       string      c:\app\administrator\diag\rdbms\ora11\ora11\trace 2. set environment in a session SQL> alter session set TIMED_STATISTICS…