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 does coalescing a tablespace do?

2 Answers  

---

pl help me, i want oracle HRMS training institute address,in chennai

8 Answers  

---

default triggers available for reports

0 Answers  

---

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

0 Answers  

---

How can you gather statistics on a table?

3 Answers  

---

what is diff between pre insert,on insert,post insert triggers?

1 Answers   IRISA,

---

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  

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

1 Answers   HCL,

---

How would you determine what sessions are connected and what resources they are waiting for?

0 Answers  

---

Describe what redo logs are.

1 Answers  

---

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

0 Answers  

---

What background process refreshes materialized views?

1 Answers  

---