Oracle: How can you enable a trace for a session?

Answer 1

to start trace:

ALTER SESSION SET sql_trace = TRUE;

to stop trace:

ALTER SESSION SET sql_trace = FALSE;

• or -

EXECUTE dbms_session.set_sql_trace (TRUE);
EXECUTE dbms_session.set_sql_trace (FALSE);

• or -

EXECUTE dbms_support.start_trace;
EXECUTE dbms_support.stop_trace;