ÉèΪÊ×Ò³ ¼ÓÈëÊÕ²Ø

TOP

bufferpoolºÍsharedpoolÏê½â£¨Ò»£©(¶þ)
2014-11-24 00:12:29 À´Ô´: ×÷Õß: ¡¾´ó ÖРС¡¿ ä¯ÀÀ:39´Î
Tags£ºbufferpool sharedpool Ïê½â
£¬µ±±»Ê¹ÓúóÒÆ¶¯µ½LRUÖ÷ListÉÏ£¨MAIN RPL_LST£©£¬ÕâÑùµ±Óû§½ø³ÌËÑË÷FreeBufferʱ¾Í¿ÉÒÔ´ÓLRU-AUX List ¿ªÊ¼£¬¶øDBWRËÑË÷Dirty Bufferʱ£¬Ôò¿ÉÒÔ´ÓLRU-Main List¿ªÊ¼£¬´Ó¶øÌá¸ßÁËËÑË÷ЧÂʺÍÊý¾Ý¿âÐÔÄÜ¡£

¿ÉÒÔͨ¹ýÈçÏÂÃüÁîת´¢Buffer CacheµÄÄÚÈÝ£¬´Ó¶øÇåÎúµÄ¿´µ½ÒÔÉÏÃèÊöµÄÊý¾Ý½á¹¹£º

\\

alter session set events 'immediate trace name buffers level4';

16:33:14 sys@felix SQL>select value from v$diag_info;

VALUE

--------------------------------------------------------------

/u01/app/oracle/diag/rdbms/felix/felix/trace/felix_ora_7187.trc

²»Í¬levelת´¢µÄÄÚÈÝÏêϸ³Ì¶È²»Í¬£¬´ËÃüÁîµÄ¿ÉÓü¶±ðÖ÷ÒªÓÐ1¡«10¼¶£¬ÆäÖи÷¼¶±ðµÄº¬ÒåÈçÏ¡£

£¨1£© Level 1£º½ö°üº¬BufferHeadersÐÅÏ¢¡£

£¨2£© Level 2£º°üº¬BufferHeadersºÍBuffer¸ÅÒªÐÅϢת´¢¡£

£¨3£© Level 3£º°üº¬BufferHeadersºÍÍêÕûBufferÄÚÈÝת´¢¡£

£¨4£© Level 4£ºLevel 1 +Latchת´¢ + LRU¶ÓÁС£

£¨5£© Level 5£ºLevel 4 +Buffer¸ÅÒªÐÅϢת´¢¡£

£¨6£© Level 6ºÍLevel 7£ºLevel 4 + ÍêÕûµÄBufferÄÚÈÝת´¢¡£

£¨7£© Level 8£ºLevel 4 + ÏÔʾusers/waitersÐÅÏ¢¡£

£¨8£© Level 9£ºLevel 5 + ÏÔʾusers/waitersÐÅÏ¢¡£

£¨9£© Level 10£ºLevel 6 + ÏÔʾusers/waitersÐÅÏ¢

ת´¢½öÏÞÓÚÔÚ²âÊÔ»·¾³ÖÐʹÓã¬×ª´¢µÄ¸ú×ÙÎļþ¿ÉÄܷdz£¾Þ´ó£¬Îª»ñÈ¡ÍêÕûµÄ¸ú×ÙÎļþ£¬½¨ÒéÉèÖóõʼ»¯²ÎÊýmax_dump_file_sizeΪUNLIMITED¡£

16:33:27 sys@felix SQL>show parameter max_dump

NAME TYPE VALUE

---------------------------------------------------------- ------------------------------

max_dump_file_size string unlimited

16:47:37 sys@felix SQL>show parametermemory_target

NAME TYPE VALUE

---------------------------------------------------------- ------------------------------

memory_target big integer 400M

16:48:46 sys@felix SQL>

²é¿´Îļþ /u01/app/oracle/diag/rdbms/felix/felix/trace/felix_ora_7187.trcÐÅÏ¢£º

´ÓLevel 4¼¶¸ú×ÙÎļþµÄ¿ªÍ·²¿·Ö¿ÉÒÔ»ñµÃÈçÏÂÐÅÏ¢£¬ÕâÊÇ ¼Ç ¼ µÄ ²» ͬListµÄPrevºÍNext¶¨Î»ÐÅÏ¢¡£ÆäÖÐWS¾ÍÊÇÖ¸WorkingSets£¬×¢ÒâWSIDÖ¸²»Í¬WSµÄ±àºÅ£º

*** 2014-07-22 16:33:13.185

*** SESSION ID:(41.237) 2014-07-22 16:33:13.185

*** CLIENT ID:() 2014-07-22 16:33:13.185

*** SERVICE NAME:(SYS$USERS) 2014-07-2216:33:13.185

*** MODULE NAME:(sqlplus@felix (TNS V1-V3))2014-07-22 16:33:13.185

*** ACTION NAME:() 2014-07-22 16:33:13.185

Dump of buffer cache at level 4 for tsn=2147483647rdba=0

(WS) size: 0 (0) wsid: 1 state: 0 pool: 1

(WS_REPL_LIST) main_prev: 0x774b2f18 main_next: 0x774b2f18 aux_prev:0x774b2f28 aux_next: 0x774b2f28

curnum:0 auxnum: 0

cold:774b2f18 hbmax: 0 hbufs: 0

(WS_WRITE_LIST) main_prev: 0x774b2f48 main_next: 0x774b2f48 aux_prev:0x774b2f58 aux_next: 0x774b2f58

curnum:0 auxnum: 0

(WS_XOBJ_LIST) main_prev: 0x774b2f78 main_next: 0x774b2f78 aux_prev:0x774b2f88 aux_next: 0x774b2f88

curnum:0 auxnum: 0

(WS_XRNG_LIST) main_prev: 0x774b2fa8 main_next: 0x774b2fa8 aux_prev:0x774b2fb8 aux_next: 0x774b2fb8

curnum:0 auxnum: 0

(WS_REQ_LIST) main_prev: 0x774b2fd8 main_next: 0x774b2fd8 aux_prev:0x774b2fe8 aux_next: 0x774b2fe8

curnum:0 auxnum: 0

(WS_L2WRT_LIST) main_prev: 0x774b3008 main_next: 0x774b3008 aux_prev:0x774b3018 aux_next: 0x774b3018

curnum:0 auxnum: 0

(WS_L2REPL_LIST) main_prev: 0x774b3038 main_next: 0x774b3038 aux_prev:0x774b3048 aux_next: 0x774b3048

curnum:0 auxnum: 0

(WS_L2KEEP_LIST) main_prev: 0x774b3068 main_next: 0x774b3068 aux_prev:0x774b3078 aux_next: 0x774b3078

curnum:0 auxnum: 0

(WS) fbwanted: 0

(WS) bgotten: 0 sumwrt: 0

(WS) pwbcnt: 0, last: 0

MAIN RPL_LST Queue header (NEXT_DIRECTION)[NULL]

½ÓÏÂÀ´ÊǾßÌåµÄListÁ´±íÐÅÏ¢£¬×¢ÒâÕâÀï´æÔÚ¶àÌõNULLÁÐ±í£¬ÕâÊÇΪBuffer Cache²»Í¬²¿·Ö£¨Keep³Ø¡¢Recycle³ØÒÔ¼°²»Í¬block_size´óСµÄÄÚ´æÊ¹Óã©Ô¤·ÖÅäµÄList£º

MAIN RPL_LST Queue header(NEXT_DIRECTION)[NULL]

MAIN RPL_LST Queue header(PREV_DIRECTION)[NULL]

AUXILIARY RPL_LST Queue header(NEXT_DIRECTION)[NULL]

AUXILIARY RPL_LST

Ê×Ò³ ÉÏÒ»Ò³ 1 2 3 4 ÏÂÒ»Ò³ βҳ 2/4/4
¡¾´ó ÖРС¡¿¡¾´òÓ¡¡¿ ¡¾·±Ìå¡¿¡¾Í¶¸å¡¿¡¾Êղء¿ ¡¾ÍƼö¡¿¡¾¾Ù±¨¡¿¡¾ÆÀÂÛ¡¿ ¡¾¹Ø±Õ¡¿ ¡¾·µ»Ø¶¥²¿¡¿
·ÖÏíµ½: 
ÉÏһƪ£ºSQLµãµÎ9¨DSQL ServerÖеÄÊÂÎñ´¦À.. ÏÂһƪ£ºMongoDBϵÁÐÖ®Èý£¨¸±±¾¼¯ÅäÖã©

ÆÀÂÛ

ÕÊ¡¡¡¡ºÅ: ÃÜÂë: (ÐÂÓû§×¢²á)
Ñé Ö¤ Âë:
±í¡¡¡¡Çé:
ÄÚ¡¡¡¡ÈÝ: