Interested to Buy Any Domain ? << Click Here >> for more details...
How can you enable a trace for a session?
- 2 Answers
- 7017 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 |
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
write a query to find the third maximum salary of a employee.(table:employ col name:salary)
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
A scenario for amount correction & how to use amount correction functionality in AP invoices
Give the stages of instance startup to a usable state where normal users may access it.
where the dff data will be stored
what is the querry to get first 10 records from the emp table?(emp no is the primary key)
Explain prerequisites and post activities of oracle database installation
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
How would you determine who has added a row to a table?
How would you determine the time zone under which a database was operating?
What is the difference between recovery and restoring of the oracle database?
Oracle General 
