Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> physical block reads vs physical reads
It states in one of Oracle's own teaching manuals, that if
physical block reads is a lot higher than physical reads, that
it's an indication that Oracle is doing a lot of FTS.
I guess this is because for every read, lots of physical blocks are
gotten
in one swoop. Is this accurate?
If so, what sort of factors are involved in this ratio - would it be MULTIBLOCK_IO_COUNT (not sure of exact spelling) only? Or are there other factors that can affect it?
Thanks,
Dc.
Received on Tue Jun 08 1999 - 23:14:04 CDT
![]() |
![]() |