What do db_file_sequential_read and db_file_scattered_read events define?

@ : Home > > Interview Room
  • db_file_sequential_read event generally indicates index usage.
  • It shows an access by row id.
  • While the db_file-scattered_read event indicates full table scan.
  • db_file_sequential_read event reads a single block at one time.
  • Whereas db_file_scattered_read event reads multiple blocks.
Alert me