Re: Tuning methodology (was T3's) and use of NetApp's

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: mgogala_at_adelphia.net

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: ListGuru_at_fatcity.com (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).