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 -> Re: conisitent gets

Re: conisitent gets

From: John Durst <jdurst_at_sky.net>
Date: Wed, 21 Oct 1998 19:03:11 -0500
Message-ID: <362E763E.7BBB37D2@sky.net>


consistent gets = blocks gotten during queries (either data or rollback blocks)
db block gets= data blocks acquired for DML operations both combined=total logical reads

John Vernes wrote:

> Hi,
>
> I just want to know what consistent gets really are!!
>
> I believe they are gets in rollback segments.
> Does a get mean a block get or the rowdata, etc????!!?
>
> Can anyone help.
>
> Thanks
>
> John
Received on Wed Oct 21 1998 - 19:03:11 CDT

Original text of this message

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