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 an Oracle database Full Backup?

0 Answers  

---

How can you rebuild an index?

1 Answers  

---

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 Answers  

---

What is the use of lockboxes? : oracle accounts receivable

0 Answers  

---

For web applications from which version of Oracle is suitable?

1 Answers  

---

Explain materialized views and how they are used.

2 Answers  

---

I am working in Oracle Clinical 4.5.1 Please explain a bit.How to create Views in OC

4 Answers   Icon,

---

What are the main diff. between oracle 7.3 and oracle 8i?

1 Answers  

---

How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun

8 Answers  

---

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

0 Answers  

---

Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....

2 Answers   Ion Exchange,

---

Explain an ORA-01555

2 Answers  

---