(tips) 10g log buffer
The LOG_BUFFER size will be set by default, by Oracle internal algorithm.
In 10G R2, Oracle combines fixed SGA area and redo buffer [log buffer] together.
If there is a free space after Oracle puts the combined buffers into a granule, that space is added to the redo buffer. Thus you see redo buffer has more space than expected. This is an expected behavior.
documents this :
"In 10.2 the log buffer is rounded up to use the rest of the granule...
The granule size can be found from the hidden parameter "_ksmg_granule_size" "
In 10G the log_buffer could fall between the log_buffer specified in spfile and the granule size.
A minimum value can be specified, but Oracle can initialize it with a bigger value, as decided by its internal algorithm.
metalink: 604351.1
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8984272/viewspace-619956/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 10g RAC rman tips
- buffer cache logical structure!Struct
- log buffer(日誌緩衝區)
- Redo Log Buffer的大小設定
- CentOS4.6安裝Oracle 10g RAC tipsCentOSOracle 10g
- log buffer space wait event等待事件AI事件
- oracle 10g logmnrOracle 10g
- oracle 10g logminerOracle 10g
- MySQL學習之change buffer 和 redo logMySql
- 【效能優化】Can the log buffer be too big?優化
- mysql innodb_log_file_size 和innodb_log_buffer_size引數MySql
- Oracle 10g Logmnr使用Oracle 10g
- 【轉】Oracle的log_buffer該設為多大?Oracle
- log_buffer的值設定多大合適
- log_buffer的記憶體分配規律記憶體
- Oracle 10g Logminer clob bugOracle 10g
- Create Logical Standby For Oracle 10GOracle 10g
- Oracle 10g glogin.sqlOracle 10gSQL
- oracle 10g中logminer的使用Oracle 10g
- 10g Supplemental Log 設定與取消
- Oracle 10g Limits - Logical Database LimitsOracle 10gMITDatabase
- log_buffer和 Redo Buffers有什麼區別啊
- 一次優化log_buffer_space的經歷優化
- 說說10g rman的catalog命令
- Oracle 10g Logminer 研究及測試Oracle 10g
- oracle 10g logical standby db creationOracle 10g
- oracle 10g data guard log apply servicesOracle 10gAPP
- Tips
- log buffer及日誌管理深入分析及效能調整(一)
- log buffer及日誌管理深入分析及效能調整(七)
- log buffer及日誌管理深入分析及效能調整(六)
- log buffer及日誌管理深入分析及效能調整(五)
- log buffer及日誌管理深入分析及效能調整(三)
- 配置 Oracle 10g RAC primary + RAC logical standbyOracle 10g
- ORACLE 10G跨RESERLOGS及list incarnationOracle 10g
- Oracle 10G的log_archive_format引數Oracle 10gHiveORM
- 使用Oracle 10g的Logminer挖掘日誌Oracle 10g
- oracle 10g跨越resetlogs恢復-incarnationOracle 10g