How can you enable a trace for a session?

Question Posted / guest

2 Answers
6894 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can you enable a trace for a session?..

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

How can you enable a trace for a session?..

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

Post New Answer

More Oracle AllOther Interview Questions

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

0 Answers

What is cardinality?

4 Answers

How do you add a data file to a tablespace?

1 Answers

how can it possibble to see the report output in excel sheet in oracle applications

4 Answers Oracle, Wipro,

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

1 Answers

why r u using etl tool.

2 Answers

write a query to find the third maximum salary of a employee.(table:employ col name:salary)

7 Answers

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

0 Answers

Can we get the deleted Record again if the delete transaction has been committed.

4 Answers

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

0 Answers

hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent

1 Answers

Could you please let me know the interfaces in OM / FA??

0 Answers Oracle,

For more Oracle AllOther Interview Questions Click Here