top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+2 votes
417 views
Oracle: How can you enable a trace for a session?
posted Apr 9, 2015 by Kunal Kapoor

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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;

answer Apr 10, 2015 by Shivaranjini
...