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

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

what is incremental checkpoint?

1 Answers   CTS,

---

What is the difference between Datapump & export/import?

2 Answers  

---

Oracle 11g new features?

2 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

Hot backup procedure?

2 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

Why would you use sql agent? : sql server DBA

0 Answers  

---

What is checkpoint?

3 Answers   Accenture,

---

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---