£¬µ±±»Ê¹ÓúóÒÆ¶¯µ½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