Hi,
Toad shows me 1)library cache hit ratio 83.7838 - dynamic or unsharable SQL?
2) Chained fetch ratio 0.024 PCTFREE too low for the table.
Do it need to increase the shared pool size if i get the dynamic or unsharable SQL hit ratio.
How to know which table has chained rows and if it has what is the solution.
Any help is appriciated.
Thanks