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 does join work in sql?

0 Answers  


How many clustered indexes can be created on a table?

0 Answers  


What is clustered and nonclustered index in sql?

0 Answers  


What does where 1 1 mean in sql?

0 Answers  


how can we submit a form without a submit button? : Sql dba

0 Answers  






What is group function in sql?

0 Answers  


What is the difference between the sql*loader and import utilities? : aql loader

0 Answers  


What is an inner join sql?

0 Answers  


What do you mean by stored procedures? How do we use it?

0 Answers  


Explian rowid, rownum? What are the psoducolumns we have?

0 Answers  


What is microsoft t sql?

0 Answers  


State few characteristics of pl/sql?

0 Answers  


Categories