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

Explain character-manipulation functions?

0 Answers  


when normalization is required

3 Answers   HCL,


What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  


what is cursor procedure

1 Answers   iGate,


How does rowid help in running a query faster?

0 Answers  






Is ms sql is free?

0 Answers  


What is the difference between a database and a relational database?

0 Answers  


Is sql a backend language?

0 Answers  


Define the select into statement.

0 Answers  


What is an inconsistent dependency?

0 Answers  


What is the usage of sql functions?

0 Answers  


how to drop an existing table in mysql? : Sql dba

0 Answers  


Categories