[计算机软件及应用]Buffer cache.pptVIP

CBC Solutions Find SQL ( Why is application hitting the block so hard? ) Nested loops, possibly Hash Partition Uses Hash Join Hash clusters Look up tables (“select language from lang_table where ...”) Change application Use plsql function Spread data out to reduce contention Select from dual Possibly use x$dual How do you find the SQL? CBC: ASH CBC: what’s the hot block Can get it from ASH Current_file# Current_block# Where event=‘latch: cache buffers chains” Sometimes file and block = 0 Seems to happen for Nested Loops Get the hot block real time Use Hash Latch Address Ash.p2 = x$bh