What are wait events. Describe the wait event tables.
- 1 Answers
- 7675 Views
- CTS, I also Faced
- E-Mail Answers
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
define sql insert statement ? : Sql dba
What is the current version of sql?
what is schema? : Sql dba
Do we need to rebuild index after truncate?
what is collation? : Sql dba
what is dbms? : Sql dba
What is your daily office routine?
what are all the common sql function? : Sql dba
Is inner join faster than left join?
how to use regular expression in pattern match conditions? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Does group by remove duplicates?
what are aggregate and scalar functions? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
Is primary key always clustered index?
