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 sql select statement?
How many rows can sqlite handle?
What does fetching a cursor do?
Is left join faster than inner join?
What is the unique index?
If a cursor is open, how can we find in a pl/sql block?
What does a pl/sql package consist of?
what is an extent ? : Sql dba
Why trigger is used in sql?
What are the subsets of sql?
Is sql the best database?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
how can I make a script that can be bi-language (supports english, german)? : Sql dba
How to sort the rows in sql.
how to check myisam tables for errors? : Sql dba