Home » RDBMS Server » Performance Tuning » PGA MEMORY LEAK (Oracle Database 11g, 11.1.0.6, RHEL x86_64)
PGA MEMORY LEAK [message #379279] Mon, 05 January 2009 19:08 Go to next message
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.
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: 4502
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: Tue Dec 06 04:42:56 CST 2016

Total time taken to generate the page: 0.27512 seconds