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

How to find locks exists in a table or not?

1 Answers   HCL,

---

HOW TO SPOT AHIERARCHY?

1 Answers  

---

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

1 Answers  

---

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

1 Answers  

---

deference between & and &&

2 Answers   Mphasis,

---

What is the use of lockboxes? : oracle accounts receivable

1 Answers  

---

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

1 Answers   Cap Gemini,

---

i want to know about the javaBean.what is its purpose and how it can use in Forms.

1 Answers   Logisoft,

---

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

1 Answers  

---

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

1 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

1 Answers  

---

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1 Answers  

---