What are wait events. Describe the wait event tables.
Answer / 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 |
Explain character-manipulation functions?
when normalization is required
What is Pragma EXECPTION_INIT ? Explain the usage ?
what is cursor procedure
How does rowid help in running a query faster?
Is ms sql is free?
What is the difference between a database and a relational database?
Is sql a backend language?
Define the select into statement.
What is an inconsistent dependency?
What is the usage of sql functions?
how to drop an existing table in mysql? : Sql dba