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 a correlated sub-query? : sql server DBA

0 Answers  

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  

---

What is a system database and what is a user database? : sql server DBA

0 Answers  

---

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers   Tech Mahindra,

---

Name two files used for network connection to a database.

5 Answers  

---

what is the difference between db2start command and start database manager command?

1 Answers  

---

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

---

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

---

why we use cursors

1 Answers  

---

What view would you use to look at the size of a data file?

3 Answers  

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

internal architecture

0 Answers   CSC,

---