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|
In testing where do we use sql language and how it helps in testing?
What is NOCOPY?
How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?
what is 'force view'?
how to retrieve the top 2 salaried persons from a database?
what is meant by forward declaration in functions?
can we call a procedure from a function?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
what is variable in package specification
Give the structure of the function ?
How can you create Cursor with parametres ?
in materialized view the structure will create immediately or not?