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

Which autogrowth database setting is good? : sql server DBA

0 Answers  

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

---

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers   Oracle,

---

Explain materialized views and how they are used.

0 Answers  

---

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

---

---

what do you understand by fine-grained auditing?

0 Answers   Oracle,

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

Can we take incremental backups in datapump?

1 Answers  

---

How to start SQL Server in minimal configuration mode?

1 Answers  

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

---

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

---