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 command would you use to create a backup control file?

2 Answers  

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

What are the recovery models for a database? : sql server DBA

0 Answers  

---

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

1 Answers   Cap Gemini, iGate,

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

---

Why would you call update statistics? : sql server DBA

0 Answers  

---

how can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,

---

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

---

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

---

Describe what redo logs are.

1 Answers  

---

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  

---

how to restore files with rman?

0 Answers  

---