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
What is data type in sql?
What is a recursive stored procedure?
Is a table valued function object?
What are sql functions? Describe the different types of sql functions?
What is benefit of creating memory optimized table?
Explain cursor types?
How do I create a memory optimized filegroup?
How are sql commands classified?
Explain the purpose of %type and %rowtype data types with the example?
which tcp/ip port does sql server run on? : Sql dba
Does inner join remove duplicates?
what are the join types in tsql? : Transact sql
What does count (*) mean?
What is mdf ldf and ndf?
What is pl sql record in oracle?