After upgrading from 11.2.0.1 64Bit database on Windows 2008 R2 SP1 to 11.2.0.3/4 ever increasing PG
After upgrading from 11.2.0.1 64Bit database on Windows 2008 R2 SP1 to 11.2.0.3/4 ever increasing PGA until all free memory is consumed and some applications must be restarted.After restarting the consumed PGA memory is freed and starts growing again.
Every 12 hours the applications must be restarted. There was no problem with 11.2.0.1 (no patch installed). Problem started with 11.2.0.3 Patchbundle 26 (the corrected one) and later on with 11.2.0.4 no patch installed.
The situation has improved after setting :.
Has anyone experienced such a phenomenon ?
Every 12 hours the applications must be restarted. There was no problem with 11.2.0.1 (no patch installed). Problem started with 11.2.0.3 Patchbundle 26 (the corrected one) and later on with 11.2.0.4 no patch installed.
The situation has improved after setting :.
alter system set events '10949 trace name context forever';
to avoid the new Direct I/O behaviour introduced with 11.2.0.2., but the PGA consuming problem still remains.Has anyone experienced such a phenomenon ?
0