Memory Footprint For Dedicated Server Processes More Than Doubled After 11g Upgrade On AIX Platform [ID 1246995.1]
Oracle Server - Enterprise Edition - Version: 220.127.116.11 and later [Release: 11.2 and later ]
IBM AIX on POWER Systems (64-bit)
o After upgrade to Oracle release 11g (18.104.22.168.0 or 22.214.171.124.0), the machine hung due to excessive memory utilization increase for each dedicated server process.
o svmon on oracle OS process id shows size of USLA, User-Space Loader Assistant, heap of about 7M bytes running Oracle release 126.96.36.199.0 on AIX platform:
svmon -P PID - where PID is an Oracle process id
Oracle Release -> (work USLA heap times 4k pages size)
188.8.131.52.0 -> 7M bytes
184.108.40.206.0 -> 60KB
10.2.0.4.0 -> 420KB
Upgrade to Oracle release 11g (220.127.116.11.0 or 18.104.22.168.0) from an earlier release 10g or 9i running on AIX platform.
This is bug 10211065 which is set to duplicate of base bug 9796810 and 10190759:
Bug 10211065.-P Base Bug 9796810
Abstract: MEMORY FOOTPRINT FOR DEDICATED SERVER PROCESSES MORE THAN DOUBLED AFTER 11G UGP
Bug 9796810.-P Base Bug 10190759
Abstract: 11G SERVER PROCESSES CONSUMING MUCH MORE MEMORY THAT 10G OR 9I
Abstract: PROCESSES CONSUMING ADDITIONAL MEMORY DUE TO 'USLA HEAP'
Oracle process consumes significantly more memory compared to earlier
releases. Utilizing the svmon command on AIX it can be seen that most of
this memory additional memory is under "Work USLA Heap" category.
If you find the memory footprint on your oracle processes has significantly
increased compared to previous releases and you are running on the AIX
platform you have likely encountered this issue.
To verify if you are hitting this issue, you can collect following information:
a) Choose one PID for a oracleSID process then execute:
svmon -P PID
genld -ld | more | /PID
b) cd $ORACLE_HOME/bin
ls -lL oracle
The additional memory seen allocated to oracle processes in the 11.2 release
is a consequence of the additional link options added to the oracle link
line, -bexpfull and -brtllib. The two link options were specifically added
in 22.214.171.124 to support the online patching feature.
Changes in the make file have been implemented such that you
can relink without these options (-bexpfull and -brtllib) to avoid
additional memory overhead incurred by adding these options.
These changes are available via a one-off patch.
To check for Patch Availability from My Oracle Support:
1) Enter Patch Name or Number: 10190759
2) Enter Platform: IBM AIX on POWER Systems (64-bit)
Note that the default behavior to install the patch, opatch apply, or link oracle
is WITHOUT the options brtllib and bexpfull:
make -f ins_rdbms.mk 'EXP_OPTS=$(EXP_OPTS_OFF)' ioracle
make -f ins_rdbms.mk ioracle
To relink oracle with these options you can execute the following on the command line to accomplish this:
make -f ins_rdbms.mk 'EXP_OPTS=$(EXP_OPTS_ON)' ioracle
The fix provided here is only seen as interim solution for the problem until such time
as a fix is provided for the run time loader on AIX by IBM.
BUG:10190759 - PROCESSES CONSUMING ADDITIONAL MEMORY DUE TO 'USLA HEAP'
BUG:10211065 - MEMORY FOOTPRINT FOR DEDICATED SERVER PROCESSES MORE THAN DOUBLED AFTER 11G UGP
BUG:9796810 - 11G SERVER PROCESSES CONSUMING MUCH MORE MEMORY THAT 10G OR 9I
Oracle 19c Automatic Indexing: Index Created But Not Actually Used (Because Your Young) - The following is an interesting example of how Oracle Automatic Indexing is currently implemented that can result in an Automatic Index being created b...
Acum 4 ore