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;

What is meant by temporal data?

977

---

Is left join faster than join?

1059

---

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1099

---

What is procedure and function in sql?

1003

---

What is the usage of nvl function?

1041

---

What is full join?

961

---

what is innodb? : Sql dba

1114

---

How does join work in sql?

1015

---

How do you explain an index number?

1114

---

Explain autonomous transaction.

1162

---

what is the difference between myisam static and myisam dynamic? : Sql dba

1068

---

What does stand for in sql?

978

---

Is primary key always clustered index?

1028

---

How is data stored in sql?

1065

---

What is before and after trigger?

964

---