cache buffer chains。trace文件

对lms进程做了个trace

发现很多cache buffer chains latch wait

WAIT #0: nam='latch: cache buffers chains' ela= 65 address=52915195616 number=122 tries=0 obj#=-1 tim=1253410761813115
WAIT #0: nam='latch: cache buffers chains' ela= 32700 address=52948332008 number=122 tries=0 obj#=-1 tim=1253410761867703
WAIT #0: nam='latch: cache buffers chains' ela= 19106 address=52948332008 number=122 tries=0 obj#=-1 tim=1253410761896664
WAIT #0: nam='latch: cache buffers chains' ela= 26 address=52946419408 number=122 tries=0 obj#=-1 tim=1253410761949195
WAIT #0: nam='latch: cache buffers chains' ela= 52009 address=52879943832 number=122 tries=0 obj#=-1 tim=1253410762015472
WAIT #0: nam='latch: cache buffers chains' ela= 9797 address=52863384296 number=122 tries=0 obj#=-1 tim=1253410762080644
WAIT #0: nam='latch: cache buffers chains' ela= 43 address=52864529696 number=122 tries=0 obj#=-1 tim=1253410762120175
WAIT #0: nam='latch: cache buffers chains' ela= 3344 address=52497889920 number=122 tries=0 obj#=-1 tim=1253410762140872
WAIT #0: nam='latch: cache buffers chains' ela= 22550 address=52864200096 number=122 tries=0 obj#=-1 tim=1253410762170470
WAIT #0: nam='latch: object queue header operation' ela= 2930 address=52347829896 number=131 tries=1 obj#=-1 tim=1253410762173485
WAIT #0: nam='latch: cache buffers chains' ela= 35922 address=52497524320 number=122 tries=0 obj#=-1 tim=1253410762219085
WAIT #0: nam='latch: cache buffers chains' ela= 5510 address=52864057696 number=122 tries=0 obj#=-1 tim=1253410762228444
WAIT #0: nam='latch: cache buffers chains' ela= 1373 address=53015645680 number=122 tries=0 obj#=-1 tim=1253410762273202
WAIT #0: nam='latch: cache buffers chains' ela= 37224 address=52362354592 number=122 tries=0 obj#=-1 tim=1253410762338866
WAIT #0: nam='latch: object queue header operation' ela= 8112 address=52364749688 number=131 tries=1 obj#=-1 tim=1253410762347056
WAIT #0: nam='latch: object queue header operation' ela= 276 address=52364749688 number=131 tries=2 obj#=-1 tim=1253410762347382
WAIT #0: nam='latch: object queue header operation' ela= 5972 address=52364749688 number=131 tries=3 obj#=-1 tim=1253410762353392
WAIT #0: nam='latch: object queue header operation' ela= 3165 address=52364749688 number=131 tries=4 obj#=-1 tim=1253410762356602
WAIT #0: nam='latch: object queue header operation' ela= 3009 address=52364749688 number=131 tries=5 obj#=-1 tim=1253410762359663
WAIT #0: nam='latch: cache buffers chains' ela= 47757 address=52948581408 number=122 tries=0 obj#=-1 tim=1253410762408338
WAIT #0: nam='latch: cache buffers chains' ela= 8365 address=52947797208 number=122 tries=0 obj#=-1 tim=1253410762433969
WAIT #0: nam='latch: object queue header operation' ela= 9035 address=52364749688 number=131 tries=1 obj#=-1 tim=1253410762443071
WAIT #0: nam='latch: cache buffers chains' ela= 37112 address=52863187896 number=122 tries=0 obj#=-1 tim=1253410762582605
WAIT #0: nam='latch: cache buffers chains' ela= 21 address=52864734896 number=122 tries=0 obj#=-1 tim=1253410762601998
WAIT #0: nam='latch: cache buffers chains' ela= 18056 address=52948585808 number=122 tries=0 obj#=-1 tim=1253410762708790
WAIT #0: nam='latch: object queue header operation' ela= 322 address=52501600840 number=131 tries=1 obj#=-1 tim=1253410762709210
WAIT #0: nam='latch: cache buffers chains' ela= 42 address=52948585808 number=122 tries=0 obj#=-1 tim=1253410762716375
WAIT #0: nam='latch: object queue header operation' ela= 2601 address=52501600840 number=131 tries=1 obj#=-1 tim=1253410762719036
WAIT #0: nam='latch: object queue header operation' ela= 30705 address=52501600840 number=131 tries=2 obj#=-1 tim=1253410762749786
WAIT #0: nam='latch: object queue header operation' ela= 2618 address=52501600840 number=131 tries=3 obj#=-1 tim=1253410762752520
WAIT #0: nam='latch: cache buffers chains' ela= 2677 address=52862727096 number=122 tries=0 obj#=-1 tim=1253410762783636
WAIT #0: nam='latch: cache buffers chains' ela= 38955 address=52945555608 number=122 tries=0 obj#=-1 tim=1253410763458659
WAIT #0: nam='latch: object queue header operation' ela= 1408 address=52364749688 number=131 tries=1 obj#=-1 tim=1253410763460185
WAIT #0: nam='latch: object queue header operation' ela= 857 address=52364749688 number=131 tries=2 obj#=-1 tim=1253410763461081
WAIT #0: nam='latch: cache buffers chains' ela= 2514 address=52947806408 number=122 tries=0 obj#=-1 tim=1253410767778692

 

定位到对象

把address=52947806408 转换成16进制，到x$bh中找出这个chain上的所有块，通过块就可以知道对象了，再细点就要更详细的信息了

select * from x$bh where hladdr = '0000000C53EF68C80';

一个buffer chain上，几十个对象啊，不好定位，看看cnt吧。

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8135069/viewspace-672557/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8135069/viewspace-672557/