ALTER SESSION SET sql_trace=TRUE;Then exercise the application. To turn off tracing, run the same command but set SQL_TRACE to FALSE. All of this will create a trace file. You can find this trace file in the directory denoted by the USER_DUMP_DEST initialization parameter.
Dig Deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.