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

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

---

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  

---

How can you rebuild an index?

6 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 do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

---

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

0 Answers  

---

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

---

Name two files used for network connection to a database.

5 Answers  

---

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

---