Adjusting the Oracle Database 10g Shared Pool.docVIP

  • 2
  • 0
  • 约7.71千字
  • 约 3页
  • 2017-08-15 发布于河南
  • 举报
Adjusting the Oracle Database 10g Shared Pool Many DBAs know that there are several queries for determining when the Oracle shared pool is too small. The library cache miss ratio tells the DBA whether to add space to the shared pool, and it represents the ratio of the sum of library cache reloads to the sum of pins. In general, if the library cache ratio is over 1, you should consider adding to the shared_pool_size. Library cache misses occur during the parsing and preparation of the execution plans for SQL statements. The compilation of a SQL statement consists of two phases: the parse ph

您可能关注的文档

文档评论(0)

1亿VIP精品文档

相关文档