Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

how are mysql timestamps seen to a user? : Sql dba

0 Answers  

What are sql constraints?

0 Answers  

How to fetch alternate records from a table?

0 Answers  

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

5 Answers   HCL, JPMorgan Chase,

What is the difference between a primary key and a clustered index?

0 Answers  

Explain about various levels of constraint.

0 Answers  

What will you get by the cursor attribute sql%rowcount?

0 Answers  

What is a bitmap index?

4 Answers   Choice Solutions, Infosys,

How to find string or key value using pl/sql code?

2 Answers   Ramco,

what is acid property in database? : Sql dba

0 Answers  

What is db journal file?

0 Answers  

What is replication id?

0 Answers