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 are the advantages and disadvantages of views in a database? : Sql dba
What is meant by temporal data?
what is heap table? : Sql dba
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
How does sql*loader handles newline characters in a record? : aql loader
What is pl/sql language case sensitive?
How bulk collect improves performance?
How to write pl sql program in mysql command prompt?
what are the different type of sql's statements ? : Sql dba
what are all types of user defined functions? : Sql dba
How much does sql cost?
tell us something about heap tables. : Sql dba
Define commit?
Explain what is table in a database?
What is java sql drivermanager?