Answer / orawhiz

Number of times processes repeatedly query the dictionary
table is called recursive hints. It is due to the data
dictionary cache is too small. By increasing the
SHARED_POOL_SIZE parameter we can optimize the size of Data
Dictionary Cache.

What is meant by recursive hints ?

1 Answers  

---

What is the maximum number of Lock Processes used?

1 Answers  

---

What are the consideration at tehe migration of Oracle 9i to 10G.

0 Answers   Baidu,

---

What is Database Buffers ?

4 Answers  

---

What is an Oracle SYSTEM tablespace and when is it Created?

0 Answers  

---

What is a Multi-threaded Server Configuration?

1 Answers  

---

How the log writer writes the data into database

4 Answers   Baidu, Satyam,

---

What is PGA?

5 Answers  

---

How will you monitor rollback segment status ?

2 Answers  

---

What is a Control file ?

4 Answers  

---

What is the maximum size of a oracle9i database?

1 Answers   Baidu, HCL, TCS,

---

How the space utilisation takes place within rollback segments?

2 Answers  

---