What are wait events. Describe the wait event tables.

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

Post New Answer

More SQL PLSQL Interview Questions

In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

4 Answers   Tech Soft,

pl/sql testing means what ...... explain process how to find pl/sql bugs

1 Answers   Zensar,

What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

3 Answers   TCS, Saama Tech,

What are Global Temporary tables

3 Answers   TCS, IBM,

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

what is a sub query?how will you calculate working days in a month using sub query?

4 Answers   InteQ,

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

what is oracle sql,pl/sql with interfaces

2 Answers   TCS,

What is the Diff b/w Constraints and Trigeer

4 Answers   HCL,

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 Answers  

what is inline command?

2 Answers