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 are mysql timestamps seen to a user? : Sql dba
What are sql constraints?
How to fetch alternate records from a table?
what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby
5 Answers HCL, JPMorgan Chase,
What is the difference between a primary key and a clustered index?
Explain about various levels of constraint.
What will you get by the cursor attribute sql%rowcount?
What is a bitmap index?
4 Answers Choice Solutions, Infosys,
How to find string or key value using pl/sql code?
what is acid property in database? : Sql dba
What is db journal file?
What is replication id?