Answer / sawant

Due to insufficient Shared SQL pool size.

Monitor the ratio of the reloads takes place while
executing SQL statements. If the ratio is
greater than 1 then increase the SHARED_POOL_SIZE.

Answer / nishi

Due to insufficient Shared SQL pool size. Monitor the ratio of the reloads takes place while executing SQL statements. If the ratio is greater than 1 then increase the SHARED_POOL_SIZE.

3. Display all the client numbers in the ORDER table. Remove duplicates.

1 Answers   Wipro,

---

What is null value in oracle?

0 Answers  

---

Difference between varchar and varchar2 data types?

0 Answers  

---

select trunc(round(156.00,-1),-1) from dual;

2 Answers  

---

How to delete a column in an existing table?

0 Answers  

---

How is it different from a normal table?

0 Answers  

---

Why we use bulk collect in oracle?

0 Answers  

---

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

2 Answers   Microsoft,

---

What is program global area (pga) in oracle?

0 Answers  

---

if you update view? where we store the data?

5 Answers   Cap Gemini,

---

Can you have more than one content canvas view attached with a window ?

0 Answers   Oracle,

---

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

2 Answers   IBM,

---