Answer Posted / myway

It is basically used in performance tuning. It is used to
get input/op statistics especially being the top five
waiting events.

What is a table index in oracle?

1187

---

What is the difference between sharding and replication?

1138

---

How to use "while" statements in oracle?

1379

---

defination of bitmap index

2180

---

How to bring a tablespace online?

1145

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1121

---

Please explain joins in oracle?

1107

---

How to convert characters to numbers in oracle?

1112

---

What is a data dictionary and how can it be created?

1240

---

What do you mean by group by clause?

1094

---

What is a oracle database?

1111

---

How to connect to oracle using service name instead of sid?

1072

---

Explain the use of rows option in exp command.

1149

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4571

---

How to define a data field as not null?

1163

---