oracle 11g 11.2.0.1ÉèÖÃHuagePageµ¼ÖÂTRC±ä´ó±ä¶à

2014-11-24 08:58:37 ¡¤ ×÷Õß: ¡¤ ä¯ÀÀ: 0
oracle 11g 11.2.0.1ÉèÖÃHuagePageµ¼ÖÂTRC±ä´ó±ä¶à
×î½ü·¢ÏÖdiag/..../trac/ Ŀ¼Ï sid_ora_xxxx.trc Îļþ´óСΪ11M ¶øÇÒÀàËÆÎļþÊýÁ¿ºÜ´ó.µ¼ÖÂÕ¼ÓÃÁË8GÓ²Å̿ռä
ÁíÍâ¸öͬÊÂ˵ËûµÄDGûÓÐÕâ¸öÎÊÌâ. ¶¼Ò»ÑùµÄϵͳºÍÒ»ÑùµÄ°æ±¾,Ψһ²»Í¬µÄÊÇËûʹÓõÄÎļþ·¾¶ ÎÒʹÓõĵ¥¾Û¼¯+ASM.
ÇëÎÊÏ 11.2.0.1µÄDG ×î´ó¿ÉÓÃģʽ,¼°Ê±»Ö¸´,Ö»¶Áģʽ.
È»ºó·¢ÏÖtracϵÄ*.trc ºÃ´ó.ƽ¾ù1¸ötrcÓÐ11M. ÀïÃæÈ«ÊÇDUMPÄÚÈÝ. ÕâÊÇʲôԭÒòÒýÆðµÄÄØ ²»¹ýÆäËûDG ²»»á
ÎÒÔÚALTER.LOG ûÕÒµ½ posdb_ora_30275.trc µÄ×Ö·û´®
Instance name: posdb
Redo thread mounted by this instance: 1
Oracle process number: 30
Unix process pid: 30275, image: oracle@posdg
*** 2013-09-10 09:36:20.584
*** SESSION ID:(840.1946) 2013-09-10 09:36:20.584
*** CLIENT ID:() 2013-09-10 09:36:20.584
*** SERVICE NAME:(SYS$USERS) 2013-09-10 09:36:20.584
*** MODULE NAME:(perl@ANYSEC-J5600 (TNS V1-V3)) 2013-09-10 09:36:20.584
*** ACTION NAME:() 2013-09-10 09:36:20.584
²»¹ý×î½ü´î½¨ºÃÁËÒ²ÓÐ1¸öÖܵÄʱ¼ä, ǰ¼¸ÌìҲûÓдËÀàÎÊÌâ, ×î½üÊǸã¸öHUGEPAGEºÍSGA_LOCK Íâ¼ÓÉÏ ÏµÍ³VMµÄÉèÖÃ.
ÏëÏÂÖ»ÓÐHUGEPAGE ¿ÉÄÜÐкܴó ÓÚÊǰÑËü¸öÈ¡ÏûµôÁË.
root@posdg:[/u01/app/database/diag/rdbms/posdg/posdb/trace]ll -h posdb_ora_*.trc
-rw-r----- 1 oracle oinstall  15K Sep 11 15:54 posdb_ora_4565.trc
-rw-r----- 1 oracle oinstall 1.2K Sep 11 15:57 posdb_ora_4617.trc
-rw-r----- 1 oracle oinstall  15K Sep 11 15:41 posdb_ora_9737.trc
-rw-r----- 1 oracle oinstall 1.6K Sep 11 15:42 posdb_ora_9881.trc
-rw-r----- 1 oracle oinstall  15K Sep 11 15:42 posdb_ora_9946.trc
-rw-r----- 1 oracle oinstall 2.1K Sep 11 15:48 posdb_ora_9997.trc
root@posdg:[/u01/app/database/diag/rdbms/posdg/posdb/trace]grep HugePages /proc/meminfo
HugePages_Total:     0
HugePages_Free:      0
HugePages_Rsvd:      0