Hi,
What does 'db_file_sequential_read' and 'db_file_scattered_read' mean?
I am interested with practical approach rather than theory definition.
Regards
Printable View
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 rowidQuote:
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 scattered read: Typically used for full table scan. Multiple blocks are read into the DB block buffer that are scattered throughout the memory.
RTFM, STFW