ORA-07445 [kghbigghs]

最近遇到的bug比較多，因此在blog上新開一個分類：BUG。

今天遇到的bug是ORA-07445 [kghbigghs]。

metalink的解釋：

Cause

The cause of this problem has been identified in Bug 2805580.
It is caused when PGA changes in size often and PGA_AGGREGATE_TARGET is used.

Solution

To fix the issue, there are the following possibilities:

(1). Use the workaround:
Set the following parameters in the init.ora/spfile and restart the database
PGA_AGGREGATE_TARGET = 0
WORKAREA_SIZE_POLICY = MANUAL

(2). Apply patchset 9205 or higher. The latest patchset (9208) is available from Metalink under .

(3). A one-off patch may be available for your platform and version under .

系統一直執行得比較穩定，升級暫時是不可能的了。

引數也不能修改，影響太大，只能先放在一邊，希望以後不再出現。