to enable trace: alter session set sql_trace=TRUE to disable trace:

How can you enable a trace for a session?

Question Posted / guest

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

Please Help Members By Posting Answers For Below Questions

Explain how to close periods in ar. : oracle accounts receivable

1312

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

1333

what are the API of GL,PO,AP

2267

types of receipts and detail desription about recipts and tables effected by receipts?

2075

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2297

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

2601

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1196

what are the tools used for oracle 10g in real time.

2441

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1276

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

2026

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7674

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2223

What view would you use to determine free space in a tablespace?

2224

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2955

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2258