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

what is the syntax for using sql_variant_property? : Transact sql

1 Answers  


How do I pipe the output of one isql to another?

1 Answers  


What is structural independence and why is it important?

1 Answers  


i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

4 Answers   Tech Mahindra,


What is foreign key and example?

1 Answers  


What are code pages ?

1 Answers   BirlaSoft,


select 10 from dual; y its showing all the rows with 10?

1 Answers  


Explain raise_application_error.

1 Answers  


What is embedded sql what are its advantages?

1 Answers  


What is sorting in sql?

1 Answers  


What is a package ? What are the advantages of packages ?

2 Answers   Symphony,


how would you get the current date in mysql? : Sql dba

1 Answers  


Categories