Oracle keeps occupying system memory on AIX.

BUG 3028673 -- Oracle on aix does not share your const structs-PER PROCESS MEMORY OVERHEAD

Oracle on ibm aix platforms (AIX 5L and 4.3.3) use a large amount of memory per dedicated connection. for Oracle 9.2 on AIX 5L the memory required per idle Oracle process appears to be about 5 Mb. A significant portion of this is related to non-shared const structures (probably about 1 Mb ). this problem is caused by the C compiler problem on AIX, so that the parts that can be shared are not shared at last, resulting in every connection process wasting about 1 MB of memory.

If you are worried that ORACLE processes are occupying too much memory due to the use of the C compiler, you can solve this problem by using the following methods. ORACLE software does not have patches, but it can be corrected by modifying system environment variables and patching the system.

If the operating system is an AIX 5.2 version, you only need to modify the environment variables.

If the operating system is AIX 5.2 or above (including 5.2), it is best to install the system patch IY49415 and RELINK the ORACLE product.

Install the aix apar IY49415 patch.

To reconnect to a database, follow these steps:

Http://updates.oracle.com/ARULink/PatchDetails/process_form? Aru = 5336110. Download the script at this location.

1) save your current version of $ ORACLE_HOME/oracle

2) create a working directory $ ORACLE_HOME/relink

3) cd to $ ORACLE_HOME/relink

4) unzip the relinking package

5) link $ ORACLE_HOME/bin/oracle to./oracle0

6) run the script./genscript to generate some required files and scripts

7) run./relink. sh to generate the new oracle binary oracle0.new. $

8) copy oracle0.new. $ to $ ORACLE_HOME/bin/oracle and verify that the permissions match the original oracle binary.