I am performing a health check on my database and the latch free event is significant..i investigated for various types of latch misses and the one that is signifcant seems to be cache buffers chain.The oracle docs says i need to find hot blocks..Now how do i find these hot blocks ?
The "cache buffer chains" tells you that the application generates/looks for HOT BLOCKS. It is a symptom not a root cause. Many SQL statements content for the same blocks. You need to identify the SQL statements and tune them. Here, statspack can help you to identify TOP 10 SQL.