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.
Amar "There is a difference between knowing the path and walking the path."
Reply With Quote
Bookmarks