On 2002.08.18 23:48 Cary Millsap wrote: > > > > 4. 'db file sequential read' does *not* typically indicate a > > full-table scan, because 'db file sequential read' events, since > > Oracle8.0 are almost always single-block read calls (before that, the > > event could indicate multi-blocks reads of sort segment blocks into a > > PGA). > > [DM] Does this parameter measure anything then? > > It shows the number of blocks read from the OS via calls to read().
I was told, in a private communication, by a person who used to work for Oracle Support that oracle is reading indexes via "read" and tables via "readv" call, indicating that a "sequential" read really refers to to reading indexes and "scattered" refers to reading tables. Is that a correct interpretation? One more thing, oracle documentation claims that oracle, as of 8i, first reserves redo copy latch and then, after that, it reserves the allocation latch. After many hours of trying, I finally gave up trying to understand the algorithm. Can you, please, shed some light on that? Thanks! -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
