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 is ora 24313?what is the procedure to exclude that error?

0 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

---

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---

What is a correlated sub-query? : sql server DBA

0 Answers  

---

---

how can you record information about current session?

0 Answers   Oracle,

---

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

What does coalescing a tablespace do?

1 Answers  

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers  

---