What Do The Db_file_sequential_read And Db_file_scattered_read Events

1.	What Do The Db_file_sequential_read And Db_file_scattered_read Events Indicate?
Answer» The db_file_sequential_read event GENERALLY INDICATES index USAGE and SHOWS an access by rowid while the db_file_scattered_read event indicates full table scan. A single block is READ at one time in the db_file_sequential_read event while multiple blocks are read parallel in the db_file_scattered_read event.

What Do The Db_file_sequential_read And Db_file_scattered_read Events Indicate?

Answer»

The db_file_sequential_read event GENERALLY INDICATES index USAGE and SHOWS an access by rowid while the db_file_scattered_read event indicates full table scan.
A single block is READ at one time in the db_file_sequential_read event while multiple blocks are read parallel in the db_file_scattered_read event.