How can you enable a trace for a session?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What Are Cross Validation & Adi?

689


how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

1908


I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1488


Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

668


What is the difference between oracle media recovery and crash recovery?

671






What is Tax Categories?

1624


can u give guidance abt packages of plsql

1644


HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

1585


What is chargeback invoice? How do we create it? : oracle accounts receivable

725


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

1734


Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2359


How would you go about increasing the buffer cache hit ratio?

1953


How many segment are present in Oracle Manufacturing

1807


What is the difference between conversions and interfaces? : oracle accounts receivable

652


What is an Oracle database Full Backup?

628