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 do you mean by hz_ in customer tables? : oracle accounts receivable

0 Answers  

---

i have marks in table,how to find total?

1 Answers  

---

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

0 Answers  

---

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

3 Answers   HP,

---

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

0 Answers   jusco,

---

Explain the difference between a data block, an extent and a segment.

1 Answers   Accenture, IBM,

---

How would you force a log switch?

1 Answers  

---

Are These Dff's Flexible?

0 Answers   Oracle,

---

How would you go about generating an EXPLAIN plan?

1 Answers   Satyam,

---

can we use lexical perameter in oracle plsql if yes how

0 Answers  

---

Olap tools

0 Answers  

---

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

0 Answers  

---