资深老专家奚哥的分享：11gR2/AIX Oracle进程相比以前版本使用较大内存的故障（USLA Head Segment ）
适用场景：
OracleDatabase - Enterprise Edition - Version 11.2.0.1 and later
IBM AIX on POWER Systems (64-bit)
背景：
在某客户系统上线的配置检查中，由于大多数利旧的机器，资源配置不是很充分，特别在内存这一块有短板，系统的SGA区是比较紧张的，比较发现，相对10g环境，内存的消耗更高，尽管连接数和sga配置都是一样的。此时感到困惑，怀疑是否进程使用内存异常。
特征：
使用svmon工具监控连接到数据库的进程，可以观察到USLA heapsize 使用异常：
# svmon -P14090370 |grep USLA 113ed91 80020014 work USLA heap sm 1901 0 0 1901 1f50175 9fffffff clnt USLA text,/dev/hd2:4170 s 13 0 - -
Oracle(work USLA heap times 4k pages size): 1901*4K=7604K 7M左右
对比10g 检查： 105*4K=420K 420K左右
相关BUG确认:
Bug10190759 AIX: Processes consuming additional memory due to"Work USLA Heap"
Affects:
Product (Component) | Oracle Server (Rdbms) |
Range of versions believed to be affected | Versions >= 11.2.0.1 but BELOW 12.1 |
Versions confirmed as being affected | |
Platforms affected | |
Fixed:
解决办法：
最新的one-off patch 基于20160419 PSU:
PROCESSES CONSUMING ADDITIONALMEMORY DUE TO 'USLA HEAP'(补丁程序 10190759)
| IBM AIX on POWER Systems (64-bit) 用于 Oracle 11.2.0.4.160419 |
2.手工链接数据库library
(1) export SHARED_SYMTAB=Y
(2)
- create under $ORACLE_HOME/rdbms/lib a file called opi.exp which will contain just this line :
opimai_real
(3)
- change the file permission to 775 (-rwxrwxr-x) :
chmod 775 opi.exp
(4) cp –p env_rdbms.mk env_rdbms.mk_ORIGINAL
(5)
- edit env_rdbms.mk under $ORACLE_HOME/rdbms/lib
- add in the list of variables :
OPI_EXP=$(RDBMSLIB)/opi.exp
- change the line 3448 from
ORACLE_LINKLINE+=$(AIO_NWAIT_TIMEOUT_EXP) -bE:$(ODM_EXP) -bE:$(LIBCOREJAVA_EXP)-bpT:0x100000000 -bpD:0x110000000 -bforceimprw -brtllib -bexpfull
to
ORACLE_LINKLINE+=$(AIO_NWAIT_TIMEOUT_EXP) -bE:$(ODM_EXP) -bE:$(LIBCOREJAVA_EXP)-bpT:0x100000000 -bpD:0x110000000 -bforceimprw -bE:$(OPI_EXP)
(6)
- run the command: relink all
Customer suggested alternative for 11.2.0.3 is to edit env_rdbms.mk line 3523to:
ORACLE_LINKLINE+= -bE:$(ODM_EXP) -bE:$(LIBCOREJAVA_EXP) $(PL_ADDR_OPTS)-bE:$(OPI_EXP)
补丁安装后需检查：
$ svmon -P 41812402 |grep USLA 15aefdb 80020014 work USLA heap s 22 0 0 22 1950115 9fffffff clnt USLA text,/dev/hd2:4170 s 14 0 - -
1901à 22 , 22*4K= 仅88K USLA的占用
-topas_nmon--p=Partitions-------Host=ebcend02-------Refresh=2secs---21:27.54---| Memory-----------------------------------------------------------------------| Physical PageSpace | pages/sec In Out | FileSystemCache|% Used 44.8% 2.7% | to Paging Space 0.0 0.0 | (numperm) 3.7%|% Free 55.2% 97.3% | to File System 0.0 48.0 | Process 34.3%|GB Used 78.9GB 0.4GB | Page Scans 0.0 | System 6.7%|GB Free 97.3GB 15.6GB | Page Cycles 0.0 | Free 55.2%|Total(GB) 176.2GB 16.0GB | PageSteals 0.0 | ------| | PageFaults 39877.0 | Total 100.0%|------------------------------------------------------------| numclient 3.7%|Min/Maxperm 17338MB( 10%) 26006MB( 14%) <--% of RAM | maxclient 14.4%|Min/Maxfree 960 1088 Total Virtual 192.2GB | User 34.2%|Min/Maxpgahead 2 8 Accessed Virtual 71.6GB 37.2%| Pinned 10.4%|-------------------------------------------------------------------------------+-topas_nmon--r=Resources--------Host=ebcend02-------Refresh=2secs---11:36.45--| Memory-----------------------------------------------------------------------| Physical PageSpace | pages/sec In Out | FileSystemCache|% Used 30.6% 1.8% | to Paging Space 0.0 0.0 | (numperm) 6.8%|% Free 69.4% 98.2% | to File System 0.0 64.0 | Process 17.1%|GB Used 54.0GB 0.3GB | Page Scans 0.0 | System 6.7%|GB Free 122.3GB 15.7GB | Page Cycles 0.0 | Free 69.4%|Total(GB) 176.2GB 16.0GB | PageSteals 0.0 | ------| | PageFaults 8729.5 | Total 100.0%|------------------------------------------------------------| numclient 6.8%|Min/Maxperm 17338MB( 10%) 26006MB( 14%) <--% of RAM | maxclient 14.4%|Min/Maxfree 960 1088 Total Virtual 192.2GB | User 20.0%|Min/Maxpgahead 2 8 Accessed Virtual 41.3GB 21.5%| Pinned 10.4%|-------------------------------------------------------------------------------
内存基于连接数，有20-30G的 free
后续分析：
该BUG主要与AIX版本相关，客户系统版本较低：AIX6106
建议如下的配置检查：
AIX 6.1 TL-07 APARIV09580, IV28319, and IV20880http://www-01.ibm.com/support/docview.wss?uid=isg1IV09580http://www-01.ibm.com/support/docview.wss?uid=isg1IV28319http://www-01.ibm.com/support/docview.wss?uid=isg1IV20880
click on "obtain the fix for this APAR;" choose 6100-07AIX 7.1 TL-01 APAR IV09541, IV28925, and IV21116http://www-01.ibm.com/support/docview.wss?uid=isg1IV09541http://www-01.ibm.com/support/docview.wss?uid=isg1IV28925http://www-01.ibm.com/support/docview.wss?uid=isg1IV21116
专家简介： 奚立新：甲骨文公司资深技术Leader，有在Oracle为大中华区各重要的客户提供技术咨询服务超过20年的经验。IT基础构架专家，精通Oracle 7/8/9/10/11体系架构，以及网络、存储、主机等层面，有着非常丰富的技术经验。 | 
|
