Глоссарий терминов Oracle
Перевод консультативная справка
Описание Oracle9i Database Release 2 provides a number of built-in intelligent advisories for performance tuning. They show Shared Pool usage to improve parse time and minimize CPU usage SQL execution memory for improvements in SQL execution time and to minimize unnecessary CPU and I/O use. For example the Shared Pool Advisory provides information on the optimal size for the library cache on your specific system. These advisories are set to go "out-of-the-box" and allow the administrator to simulate a variety of hypothetical scenarios.