Answer / guest

Enable trace at session level

( A )to start trace:

ALTER SESSION SET sql_trace = TRUE;

- or -
EXECUTE dbms_session.set_sql_trace (TRUE);

- or -


EXECUTE dbms_support.start_trace;


(B) to stop trace:

ALTER SESSION SET sql_trace = FALSE;

- or -

EXECUTE dbms_session.set_sql_trace (FALSE);

- or -

EXECUTE dbms_support.stop_trace;


Regards
Abhinav Phadnis

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers  

---

Explain the use of table functions.

1 Answers  

---

Oracle 11g new features?

2 Answers  

---

How would you determine who has added a row to a table?

4 Answers  

---

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers  

---

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

how can you enable flashback feature?

0 Answers   Oracle,

---

How do you add a data file to a tablespace?

3 Answers  

---

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---