Oracle Shared pool Pinning Techniques

Concept:

The oracle Shared pool is the area where things (objects) are loaded for execution compilation (all database operations).
Pinning refers to the concept of keeping an object in the shared pool area.
The main reason to keep objects in shared memory is to improve system performance.
If the object is a code object such as a procedure, package, etc., you can pin the code in the cache to stop it from being removed.


How about you try to find out which objects are being loaded way to many times into the shared pool ?


Read Full Article
-thanks for reading