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 |
Define commit, rollback and savepoint?
How do you write an inner join query?
What is the primary use of normalization?
What sql database should I use?
What are sql queries used for?
How is a PL/SQL code compiled?
what are the advantages of cursors than procedures?
What is embedded sql with example?
i want run a sql query query? which phases are run in a back ground? pls tell me the answer
Can a key be both primary and foreign?
What is primary key and foreign key with example?
What is a stored procedure in sql with example?
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)