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 are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

0 Answers   HP,

---

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 Answers  

---

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

0 Answers  

---

What is the sql query to find the employee who has Nth maximum salary?

2 Answers  

---

What is the difference between the SQL*Loader and IMPORT utilities?

1 Answers  

---

Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

0 Answers   Punjab National Bank,

---

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

0 Answers   TCS,

---

What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?

2 Answers   CTS,

---

i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value

6 Answers   IBM,

---

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

1 Answers   HCL,

---

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

1 Answers   Alshaya,

---

Why more redos are generated when the oracle database is in begin backup mode?

0 Answers  

---