I will explain DB File Scattered Read Wait event in Oracle in this post.   DB File Scattered Read in Oracle This wait event occurs getting multiblock of physical blocks that are not physically close to each other (neighbors) into buffer cache Scattered, or during a full scan to the buffer cache. So Db file … Continue reading DB File Scattered Read Wait event in Oracle