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

how can you record information about current session?

1040

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1072

---

What is the default port no on which sql server listens? : sql server DBA

1148

---

what do you understand by flashback feature of oracle?

985

---

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

1970

---

Explain materialized views and how they are used.

2436

---

What is dcl? : sql server DBA

1255

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1193

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1104

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2559

---

internal architecture

2184

---

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

988

---

What is dbcc? : sql server DBA

1280

---

What happens on checkpoint? : sql server DBA

1086

---

what are the performance views in an oracle rac environment?

1049

---