What Do You Understand By Db File Scattered Read?

1.	What Do You Understand By Db File Scattered Read?
Answer» DB FILE scattered READ indicates a scatter read into multiple discontinuous locations. It generally indicates FULL table scan and that multiple blocks are being read into memory. Such reads are CALLED scattered read calls, because the blocks are scattered throughout memory.

Answer»

DB FILE scattered READ indicates a scatter read into multiple discontinuous locations.
It generally indicates FULL table scan and that multiple blocks are being read into memory.
Such reads are CALLED scattered read calls, because the blocks are scattered throughout memory.

Discussion