The Shared Pool is an area of the SGA that stores parsed SQL statements, data dictionary information, and some session information. The Shared Pool reduces parse overhead by caching frequently executed SQL statements.
This alarm occurs when the Shared Pool is set too small. A possible cause is the use of literals rather than bind variables in SQL statements. You can also increase the size of the Shared Pool.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center