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

What is the difference between anonymous block and named blocks?

3 Answers  


please explain database architecture..

1 Answers   Infosys,


display null value rows with out using null function?

8 Answers   Infosys,


in procedure how to return a value

3 Answers   Wipro,


Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  






Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

5 Answers  


Can we write create command in the plsql block?if possible how?

2 Answers  


how can create data base link for tow servers (scott schema) give examples plz

2 Answers  


With out using count() function. How to the find total number of rows in a table?

6 Answers  


when normalization is required

3 Answers   HCL,


why not null constraint showing its constraint type as 'c'

1 Answers  


What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,






Categories