oracle10.2.0.2 bug "AUTO SGA: Not free

zhulch發表於2007-02-08
.....[@more@]

今天隨便開啟一個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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章