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 |
What is Temp Table and type of temp table?
how to write date and time literals? : Sql dba
What is basic structure of pl sql?
Which command is used to delete a trigger?
Is sql scripting language?
What is different between union and minus?
What are Lexical Parameters.How They are used in Reports 6i
Is pl sql still used?
Why use stored procedures?
what is the difference between trigger and constraint?
Can we rename a column in the output of sql query?
How can you load multi line records? : aql loader
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)