What are wait events. Describe the wait event tables.

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What makes a good primary key?

729


What schema means?

676


what is unique key constraint? : Sql dba

740


how to return query output in html format? : Sql dba

847


What is the use of triggers?

736






What is compiled query?

744


what are the join types in tsql? : Transact sql

755


Enlist the advantages of sql.

744


what is the difference between delete and truncate commands? : Sql dba

722


Is nosql faster than sql?

745


How do I start pl sql?

668


What is orm in sql?

723


List the different type of joins?

750


What are different types of functions in sql?

723


what are the differences between binary and varbinary? : Sql dba

717