Question about the IO on full table scan operation

[hsienwen chu <chu.hsien.wen@xxxxxxxxx>]

Dear all

the situation is that:  I have a table, and the size is about 10M, I run the database on Redhat Linux platform. for OS, a IO can hand 1M data, the file system block is 4k, database block is 8k,

my question is that: when do the full table scan on the table, how many IO will be done?     10M/1M=10 ?    or 10M/8k=1280?  or 10M/4k=2560?    

I'm confuse for this, does any could help me?


Many Thanks
Tony