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