首页 > 数据库 > 数据库开发技术 > Cache the Data Dictionary for Fast Access (264)

Cache the Data Dictionary for Fast Access (264)

原创 数据库开发技术 作者:tsinglee 时间:2007-11-28 10:50:08 0 删除 编辑

Much of the data dictionary information is kept in the SGA in the dictionary cache,
because Oracle constantly accesses the data dictionary during database operation to
validate user access and to verify the state of schema objects. All information is stored
in memory using the least recently used (LRU) algorithm.

Parsing information is typically kept in the caches. The COMMENTS columns describing
the tables and their columns are not cached unless they are accessed frequently.

1. 大多数的数据字典信息被缓存到SGA中的字典缓冲区 ,使用最近最少使用算法
2. 解析信息就是代表性的保存在缓存中


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
  • 博文量
  • 访问量