Dynamic or unsharable sql

[prince_jr]

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

[naqi]

Toad, has given you a few stats. The question is though, is your system experiencing any performance problems? Have users complained to you?
A better place to perhaps look is in the v$session_Wait views to see what sessions are waiting and for how long.

On the library cache, have a look athe v$sgastat, look for how much free memory there is in your shared pool. If its a large amount, adding more would just be a waste. That memory could perhaps be better utilized elsewhere