Cache the Data Dictionary for Fast Access (264)
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部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-985483/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Keeping the Data Dictionary Cache Hit Ratio at or above 95 Percent
- 什麼是 SAP ABAP FDA - Fast Data Access 技術?AST
- data dictionary(資料字典)
- About Static Data Dictionary ViewsView
- Structure of the Data Dictionary : Base Tables (258)Struct
- 通過Cache::Memcached::Fast方式AST
- How Oracle Uses the Data Dictionary (262)Oracle
- Public Synonyms for Data Dictionary Views (263)View
- H.264碼流結構 (H.264 Data Structure)Struct
- How to get ORACLE_HOME from data dictionaryOracle
- Structure of the Data Dictionary : User-Accessible Views (259)StructView
- Step 9: Run Scripts to Build Data Dictionary Views (67)UIView
- note of Beginning Oracle SQL-Oracle Data Dictionary ViewsOracleSQLView
- 【YashanDB知識庫】YAS-00103 no free block in dictionary cacheBloC
- school dictionary, kids dictionary, children dictionary
- View and Data API tips: 快取Access TokenViewAPI快取
- data buffer cache的一點總結。
- Data Guard Broker系列之六:Fast-Start FailoverASTAI
- Oracle 19c Concepts(06):Data Dictionary and Dynamic Performance ViewsOracleORMView
- DevExpress v17.2新版亮點——Data AccessdevExpress
- ADO在MICROSOFT DATA ACCESS 中的角色 (轉)ROS
- data buffer cache的一點總結 -- 轉
- Oracle10g資料字典(Data Dictionary for Oracle 10g)-ztOracle 10g
- SAP Data Intelligence API如何獲得Access TokenIntelAPI
- SAP Hybris和ABAP Netweaver裡的DAO(Data access object)Object
- MongoDB:Read and write access to data and configuration is unrestricted.MongoDBREST
- Enterprise Library - Data Access Application Block 6.0.1304APPBloC
- c#訪問oracle幾種方法(轉載)_data accessC#Oracle
- Oracle Data Guard快速啟動故障切換 - fast-start failover(FSFO)OracleASTAI
- [H264]解密純264檔案格式解密
- SQL*Net more data from dblink引起library cache pinSQL
- PHP設計模式-DAO (Data Access Objects) 資料訪問物件模式PHP設計模式Object物件
- ARABIC-ENGLISH DICTIONARY: THE HANS WEHR DICTIONARY OF MODERN WRITTEN ARABIC
- dataGridView繫結Dictionary |Dictionary繫結到DataGridViewView
- Oracle10g data buffer cache的記憶體結構Oracle記憶體
- iOS:對array,dictionary,set的分析,對dictionary的改進iOS
- Some Dictionary Views For ASMViewASM
- Dictionary<string, object>Object