Re: consistent gets not equal to number of rows

On Feb 1, 3:54 pm, "Jonathan Lewis" <jonat..._at_jlcomp.demon.co.uk> wrote:
> <bdurrettc..._at_yahoo.com> wrote in message
>
> Tablescans are a particularly easy example - especially
> if you do a simple aggregate. As you guessed, Oracle
> gets the block once and the picks rows out of it while
> "pinning" it.
>
> If you did a tablescan returning actual rows, and set a
> small arraysize for the fetch, you would see Oracle
> getting the block, pinning it to fill the array, then letting
> it go; then coming back to pin it for the next fetch.
>
> There's some information I wrote about the whole
> process here:
> http://www.dizwell.com/prod/node/342
>
> --
> Regards
>
> Jonathan Lewishttp://jonathanlewis.wordpress.com

Very helpful. Thanks.

• Bobby