DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Dynamic or unsharable sql

    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.

  2. #2
    Join Date
    Jul 2003
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.