Answer / guest

to enable trace:

alter session set sql_trace=TRUE

to disable trace:

alter session set sql_trace=FALSE

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#);

What is the mandatory setup in cyclecount ?

0 Answers   Oracle,

---

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

0 Answers  

---

What is index? How many types of indexes?

2 Answers   HCL,

---

When creating a user, what permissions must you grant to allow them to connect to the database?

4 Answers  

---

can we drop dual table

7 Answers   Metric Stream,

---

Give the two types of tables involved in producing a star schema and the type of data they hold.

1 Answers  

---

please explain about oracle

1 Answers  

---

How can you enable a trace for a session?

2 Answers  

---

What is autocashrule set? : oracle accounts receivable

0 Answers  

---

3. Steps in UAT?

0 Answers   Oracle,

---

Explain an ORA-01555

2 Answers  

---