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.

THE MAIN CONCEPT OF PROGRAMMIN TYPE?

1 Answers  

---

What is a Parallel Server option in ORACLE?

1 Answers  

---

What are the components of SGA?

5 Answers  

---

Why query fails sometimes ?

1 Answers  

---

What is Shared SQL Area?

1 Answers   Oracle,

---

What Does DBWR do?

2 Answers   Honeywell,

---

What is the role of PCTFREE parameter is Storage clause ?

2 Answers  

---

What is Dedicated Server Configuration?

2 Answers   IR Consulting,

---

What is function of RECO?

1 Answers  

---

What constitute an ORACLE Instance?

2 Answers  

---

What is the function of ARCH?

3 Answers  

---

What is the use of Oracle Control File?

0 Answers  

---