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 the syntax for using sql_variant_property? : Transact sql
How do I pipe the output of one isql to another?
What is structural independence and why is it important?
i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?
What is foreign key and example?
What are code pages ?
select 10 from dual; y its showing all the rows with 10?
Explain raise_application_error.
What is embedded sql what are its advantages?
What is sorting in sql?
What is a package ? What are the advantages of packages ?
how would you get the current date in mysql? : Sql dba
Oracle (3253)
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)