in Oracle,
“The library cache includes the shared SQL areas, private SQL areas (in the case of a multiple transaction server), PL/SQL procedures and packages, and control structures such as locks and library cache handles.
Shared SQL areas are accessible to all users, so the library cache is contained in the shared pool within the SGA.”
To tune Library Cache, we also need to calculate GetHit Ratio and PinHit Ratio.
)
Also, reference the scripts offered at http://www.dba-oracle.com/concepts/pinned_objects.htm
There are two scripts useful there.
- Show Objects Which Should Be Kept
- use DBMS_SHARED_POOL.KEEP to retain object in library cache
Besides of above, Parse Ratio and Recursive Call Ratio also need to be paid attention to.
(Script for
)
Another helpful scripts for tuning library cache hit ratio is available at http://www.oracledba.co.uk/tips/choose.htm
That is very inspirational stuff. Never known that feeling can be this diversified. Thanks for all the enthusiasm to extend such helpful information on this post. . . .