Home » RDBMS Server » Performance Tuning » PGA MEMORY LEAK (Oracle Database 11g,, RHEL x86_64)
PGA MEMORY LEAK [message #379279] Mon, 05 January 2009 19:08 Go to next message
Messages: 34
Registered: September 2008

Hello Everyone,

I recently found a bug in Oracle Database 11g version 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 upgrade patch and upgrade the database to

Hope this helps all those who are facing performance degradation issue on an Oracle Database 11g version

Thank You.
Re: PGA MEMORY LEAK [message #379339 is a reply to message #379279] Tue, 06 January 2009 02:26 Go to previous message
Frank Naude
Messages: 4509
Registered: April 1998
Senior Member
Good information! Thanks for sharing it with us.
Previous Topic: Primary key index not working proper after import
Next Topic: Pga hit ratio
Goto Forum:

Current Time: Sun Jul 23 10:18:59 CDT 2017

Total time taken to generate the page: 0.05115 seconds