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 would you go about increasing the buffer cache hit ratio?

0 Answers  

---

Can we get the deleted Record again if the delete transaction has been committed.

4 Answers  

---

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

0 Answers   Pathway Technologies,

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

How do you add a data file to a tablespace?

1 Answers  

---

How would you go about generating an EXPLAIN plan?

1 Answers   Satyam,

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

how can it possibble to see the report output in excel sheet in oracle applications

4 Answers   Oracle, Wipro,

---

Explain the payment term in ar. : oracle accounts receivable

0 Answers  

---

How do you use trigger to create mutating state of table

2 Answers   TCS,

---

Describe the P2P cycle ?

1 Answers  

---