Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

RE: [suse-oracle] disk read and processes

Kevin Closson

2006-09-21

Replies:


>>>
>>>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

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.