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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [20191211]Free SGA Memory Available.txtAI
- 碰到一個latch free相關的BUG
- 【BUG】ORA-00600 [4506] [ktubko_1] CDB模式,rac下不懂sga會觸發相關bug模式
- LOCK_SGA(zt)
- Auto CAD
- free命令
- [20210723]Minimum sga_target.txt
- SGA: allocation forcing component growth分析
- auto型別型別
- 說說 auto
- ordebug 手動修改Oracle sga scnOracle
- Oracle Free Buffer WaitsOracleAI
- [LeetCode] Employee Free TimeLeetCode
- redis:auto-completeRedis
- z-index:autoIndex
- Auto關鍵字
- [Vue] Routes auto generatorVue
- 聊聊dba_temp_free_space的allocated_space和free_space
- WINDOWS平臺上擴充套件SGA (zt)Windows套件
- statistics_level與SGA_TARGET衝突
- 一次SGA與Swap故障診斷
- [20210423]dump sga映像的對應塊.txt
- [20210421]如何使用dumpsga轉儲sga.txt
- AUTO START ORACLE ON LINUX(zt)OracleLinux
- Latch free等待事件(轉)事件
- [轉帖]剖析free命令
- SAP QM Auto Usage Decision
- Use-After-Free漏洞
- Oracle Rac 修改SGA_TARGET值無變化Oracle
- 一次Oracle診斷案例-SGA與SwapOracle
- Oracle Exadata與SGA快取記憶體CQOracle快取記憶體
- Latch free等待事件四(轉)事件
- Latch free等待事件三(轉)事件
- free 與 CFRelease 的區別
- 深入解析decltype和decltype(auto)
- free Generative AI courses All In OneAI
- 使用 go 理解 Lock-FreeGo
- Latch free等待事件二(轉)事件
- 新增 fontawesome-free 出錯