Hi !

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.

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