What are wait events. Describe the wait event tables.

What are wait events. Describe the wait event tables...

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;

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

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,