How can you enable a trace for a session?
- 2 Answers
- 6328 Views
- I also Faced
- E-Mail Answers
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 is chargeback invoice? How do we create it? : oracle accounts receivable
please send me oracle pl/sql exp resume. and also faqs...
Name three advisory statistics you can collect.
Name two files used for network connection to a database.
default triggers available for reports
Describe the P2P cycle ?
What is the mandatory setup in cyclecount ?
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
What is the use of lockboxes? : oracle accounts receivable
What is Restricted Mode of Instance Startup in Oracle?
What is the Query Optimizer. How you optimize your qeury.
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
Oracle General 
