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 do you understand by fine-grained auditing?

1062

---

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

999

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2504

---

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.

2170

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2284

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2305

---

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

1000

---

What is transparent data encryption? : sql server DBA

1199

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1082

---

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

7923

---

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.

1735

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2050

---

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

1119

---

What purpose does the model database server? : sql server DBA

1198

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1998

---