Answer / guest

Enable trace at session level

( A )to start trace:

ALTER SESSION SET sql_trace = TRUE;

- or -
EXECUTE dbms_session.set_sql_trace (TRUE);

- or -


EXECUTE dbms_support.start_trace;


(B) to stop trace:

ALTER SESSION SET sql_trace = FALSE;

- or -

EXECUTE dbms_session.set_sql_trace (FALSE);

- or -

EXECUTE dbms_support.stop_trace;


Regards
Abhinav Phadnis

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---

What purpose does the model database server? : sql server DBA

0 Answers  

---

what is incremental checkpoint?

1 Answers   CTS,

---

What would you do with an "in-doubt" distributed transaction?

0 Answers  

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

How would you force a log switch?

4 Answers  

---

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

---

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---