there are hot spots in buffer cache as well but the concept is basically the same as datafiles, to check for hot spots in buffer cache you have to check for cache buffer chain latch from v$latch_children then join with x$bh (addr and laddr) and order by touch counts in x$bh