What are wait events. Describe the wait event tables.
Answer Posted / 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 View All Answers
Which type of cursor is used to execute the dml statement?
What is the use of triggers?
What is the use of non clustered index?
Explain the purpose of %type and %rowtype data types with the example?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
What is procedure explain with example?
what is 'trigger' in sql? : Sql dba
What is the use of desc in sql?
What is recursive stored procedure?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is sql resultset?
Is sql harder than python?
What do you mean by rowid?
How long will it take to learn pl sql?
What are properties of the transaction?