Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> physical block reads vs physical reads

physical block reads vs physical reads

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Wed, 09 Jun 1999 00:14:04 -0400
Message-ID: <375DEA0C.76169B0@bigfoot.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US