Originally posted by sumit
Hi,

What does 'db_file_sequential_read' and 'db_file_scattered_read' mean?

I am interested with practical approach rather than theory definition.
Regards
db file sequential read: Single block read commonly seen for index block access or table block access by a rowid

db file scattered read: Typically used for full table scan. Multiple blocks are read into the DB block buffer that are scattered throughout the memory.