Any papers on how to calculate how many LIOs a query should use? For example I had a full table scan of a 1 MB table with 8kb blocksizes.
The table was in memory, so no additional LIOs for hitting the storage. How do I calculate how many LIOs I should get? I actually go 63? Same for different types of index reads?
Not an absolute necessity. I'd just like to know. Or maybe we can discuss it on here?
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at
http://www.freelists.org/archives/oracle-l/
FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html
Received on Fri Aug 13 2004 - 09:36:52 CDT
