Follow Our FB Page << CircleMedia.in >> 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  


Categories