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 asm?

0 Answers   Oracle,

---

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  

---

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  

---

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

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,

---

orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---

What is checkpoint?

3 Answers   Accenture,

---

Explain about your sql server dba experience? : sql server DBA

0 Answers  

---