| PGA MEMORY LEAK [message #379279] |
Mon, 05 January 2009 19:08  |
andydba
Messages: 34
Registered: September 2008
|
Member |
|
|
Hello Everyone,
I recently found a bug in Oracle Database 11g version 11.1.0.6 and wanted to share it with all of you (if you are not aware of it).
A PGA memory leak can be seen when session cached cursors is enabled and there are triggers on the table on which DML is performed.
This can cause a gradual degradation of DML performance.
The leak occurs in the "kxs-heap-p" subheap and contains chunks labeled as "kxt.c: PL/SQL p" / "kxt.c: Trigger ".
There are two workaround to this
1. SET SESSION_CACHED_CURSORS init.ora parameter to ZERO.
2. Install 11.1.0.7 upgrade patch and upgrade the database to
11.1.0.7.
Hope this helps all those who are facing performance degradation issue on an Oracle Database 11g version 11.1.0.6.
Thank You.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
