-
Dynamic or unsharable sql
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|