Answer Posted / 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 differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1002

---

Which autogrowth database setting is good? : sql server DBA

1155

---

how can you find out if a table can be redefined?

1012

---

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?

1985

---

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

2107

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2041

---

what is the use of recording information about current session?

1053

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1975

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1759

---

What happens on checkpoint? : sql server DBA

1093

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2167

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1905

---

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

2618

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2463

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2409

---