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 |
How to add new employee details in an employee_details table with the following details
Explain the uses of a database trigger?
what is External tables? explain with examples
how does a local variable is defined using t-sql? : Transact sql
pl/sql testing means what ...... explain process how to find pl/sql bugs
how to show all tables with 'mysql'? : Sql dba
Authentication mechanisms in Sql Server ?
Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.
how to enter characters as hex numbers? : Sql dba
What are sql objects?
What is the diff between Truncate table / delete <table name> purge
Are subqueries faster than joins?
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)