Creating trace file

• Enable SQL trace

  • ALTER SESSION SET SQL_TRACE = TRUE;

• Run SQL script, eg

  • select PERSONID from account where accountid < 1000300;

• Disable SQL trace

  • ALTER SESSION SET SQL_TRACE = FALSE;

• The trace file should now be generated with a given name, eg: ORA00333.TRC

Notes: