oracle10.2.0.2 bug "AUTO SGA: Not free
今天隨便開啟一個trace file 的時候,發現裡面有大量的“AUTO SGA: Not free ”
於是,檢查SGA/記憶體使用情況等等,沒發現任何異常,最後向METALINK 發TAR ,
發現是個BUG ,並不是因為SGA 真的不夠了。
*** 2007-02-06 21:00:04.582
*** SERVICE NAME:(SYS$BACKGROUND) 2007-02-06 21:00:04.577
*** SESSION ID:(388.1) 2007-02-06 21:00:04.577
AUTO SGA: Not free 0x70000016df8dc18, 1, 1, 1
AUTO SGA: Not free 0x70000016df8dc18, 1, 1, 1
AUTO SGA: Not free 0x70000016df8dd18, 1, 1, 1
AUTO SGA: Not free 0x70000016df8de18, 1, 1, 1
AUTO SGA: Not free 0x70000016df8df18, 1, 1, 1
AUTO SGA: Not free 0x70000016df8e018, 1, 1, 1
AUTO SGA: Not free 0x70000016df8e118, 1, 1, 1
AUTO SGA: Not free 0x70000016df8e218, 1, 1, 1
AUTO SGA: Not free 0x70000016df8e318, 1, 1, 1
AUTO SGA: Not free 0x70000016df8e418, 1, 1, 1
This is due to Bug 5201883 - UNEXPLAINED MMAN TRACE FILE in 10.2.0.2 and 10.2.0.3
CAUSE JUSTIFICATION
===================
Bug 5201883 - UNEXPLAINED MMAN TRACE FILE in 10.2.0.2 and 10.2.0.3
PROPOSED SOLUTION(S)
====================
Please apply the patch for Bug 5201883 - UNEXPLAINED MMAN TRACE FILE in 10.2.0.2 and 10.2.0.3 by downloading it fro metalink.
PROPOSED SOLUTION JUSTIFICATION(S)
==================================
This is due to bug. This does not indicate that SGA is insufficient. As such these
errors can be ignored.
SOLUTION / ACTION PLAN
======================
-- To implement the solution, please execute the following steps::
Please apply the patch for Bug 5201883
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7318139/viewspace-898544/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ordebug 手動修改Oracle sga scnOracle
- BUG管理系統運維記錄(bugfree)運維
- CentOS安裝搭建BugFreeCentOS
- Subversion、BugFree安裝指南
- 開源Bug跟蹤管理工具–BugFree
- 在wamp下安裝bugfree
- BugFree環境搭建及使用
- FreeBSD系統上如何安裝Bugzilla?FreeBSD系統安裝Bugzilla的方法教程
- [20191211]Free SGA Memory Available.txtAI
- 修改sga_target引起的ora-27100 bug嗎
- oracle 10.2.0.1的小bug:Memory NotificationLibrary Cache Object Loaded Into SgaOracleObject
- [轉]10.2.0.1的小bug:Memory NotificationLibrary Cache Object Loaded Into SgaObject
- Fixed the bug:while running alert/confirm in javascript the chrome freezesWhileJavaScriptChrome
- 【BUG】ORA-00600 [4506] [ktubko_1] CDB模式,rac下不懂sga會觸發相關bug模式
- IE CSS Bug系列:IE8中按鈕使用Auto-Margin居中失效CSS
- bugfree在win7(64位)平臺的搭建Win7
- sga_target與sga_max_size
- SGA_MAX_SIZE與SGA_TARGET
- sga_target與max_sga_size
- Android Auto-Building Apps for Auto,Getting Started with AutoAndroidUIAPP
- show sga和show parameter sga的區別
- 【轉】SGA_MAX_SIZE與SGA_TARGET
- 軟體開發BUG跟蹤之BUGFREE建立解決郵件傳送問題(windows)Windows
- 自動SGA共享記憶體管理,ASMM,MMAN,sga_target,sga_max_size記憶體ASM
- Bugfree郵件傳送設定(以QQ郵箱為例)
- auto型別型別
- inherit與auto
- Auto CAD
- android auto-Providing Audio Playback for AutoAndroid
- 解決Bugfree不能定期傳送統計郵件的問題
- Large SGA On LinuxLinux
- 記憶體_SGA記憶體
- oracle sga相關Oracle
- Sga的結構
- oracle sga構成Oracle
- 使用lock_sga和pre_page_sga引數保證SGA常駐實體記憶體記憶體
- 關於 MYSQL auto_increment_offset和auto_increment_incrementMySqlREM
- mysql的auto_increment_offset和auto_increment_increment配置MySqlREM