>>>
>>>scattered reads ARE Full-Table-Scans, it's confusing, but i
>>>found it out 1 year ago (after 12 Years of Oracle ... tststs).
>>>sequential reads are direct block scans, not FTS.

If the access method is FULL (FTS), the OSDs will use
either scattered read or direct path read depending on PQO or not.

Scattered reads are also used for index range scans with
or without PQO.

db file sequential reads are single block reads.



>>>
>>>But you're right:
>>>FTS with PQ are not using/filling DB-Buffers.
>>>non FTS with PQ are using/filling DB-Buffers.
>>>
>>>Bye
>>>  Frank
>>>
>>>----- Original Message -----
>>>From: "Kevin Closson" <kevinc@(protected)>
>>>To: <suse-oracle@(protected)>
>>>Sent: Thursday, September 21, 2006 6:11 PM
>>>Subject: RE: [suse-oracle] disk read and processes
>>>
>>>
>>>
>>>>>>
>>>>>>Keep in mind: PQ is not moving the read blocks into the
>>>>>>buffer-pool, so the benefit of these fast reads is only for
>>>>>>the current statement, not the other sessions on the same
>>>>>>object on the same instance!
>>>
>>>not always true. PQO will perform index range scans which
>>>are scattered reads (SGA buffers).
>>>
>>>
>>>
>>>--
>>>To unsubscribe, email: suse-oracle-unsubscribe@(protected)
>>>For additional commands, email: suse-oracle-help@(protected)
>>>Please see http://www.suse.com/oracle/ before posting
>>>
>>>
>>>
>>>
>>>
>>>--
>>>To unsubscribe, email: suse-oracle-unsubscribe@(protected)
>>>For additional commands, email: suse-oracle-help@(protected)
>>>Please see http://www.suse.com/oracle/ before posting
>>>
>>>

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting