Answer / surya

Many of these wait events are tied to the internal implementation of Oracle and therefore are subject to change or deletion without notice. Application developers should be aware of this and write their code to tolerate missing or extra wait events.

The following SQL statement displays an alphabetical list of all Oracle wait events and the wait class to which they belong:

SQL> SELECT name, wait_class FROM V$EVENT_NAME ORDER BY name;

In testing where do we use sql language and how it helps in testing?

2 Answers  

---

What is NOCOPY?

6 Answers   DELL,

---

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,

---

what is 'force view'?

3 Answers   Cap Gemini, SPIC,

---

how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,

---

---

what is meant by forward declaration in functions?

4 Answers   TCS,

---

can we call a procedure from a function?

9 Answers   Mind Tree,

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

0 Answers  

---

what is variable in package specification

2 Answers  

---

Give the structure of the function ?

2 Answers  

---

How can you create Cursor with parametres ?

3 Answers  

---

in materialized view the structure will create immediately or not?

2 Answers   iFlex,

---