How can you enable a trace for a session?
Answers were Sorted based on User's Feedback
Answer / guest
to enable trace:
alter session set sql_trace=TRUE
to disable trace:
alter session set sql_trace=FALSE
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / anji
to enable the trace in anther session
EXECUTE dbms_support.start_trace_in_session (sid,serial#);
To stop the trace in anther session
EXECUTE dbms_support.start_trace_in_session (sid,serial#);
Is This Answer Correct ? | 2 Yes | 0 No |
What do you mean by hz_ in customer tables? : oracle accounts receivable
What is Virtual Memory?
How do you use trigger to create mutating state of table
What is the Symbol use for Inner Join
can we use lexical perameter in oracle plsql if yes how
What is the difference between recovery and restoring of the oracle database?
Compare and contrast TRUNCATE and DELETE for a table.
please explain about oracle
When the procedures or packagess become invalidate
What is the mandatory setup in cyclecount ?
How many segment are present in Oracle Manufacturing
What is the disk migration? what is the steps involved in oracle disk migration?