Re: What is consistent get?

This is my understanding of consistent gets. Can anyone please confirm this? Your ORACLE instance has an SGA. The SGA resides in RAM. One important component in SGA is data buffer cache. Your table is stored in a tablespace and the tablespace will have one or more datafiles. When you request data from a table, you could get them either from the datafile (physical read) or data buffer cache (logical read).
Now, data in the data buffer cache could correspond to a table segment or rollback segment. My inderstanding is that, data in data buffer cache, corresponding to a table segment is db_block_read and in the rollback segment is a consistent get.
If your query requests read-consistent data a consistent get would happen. Hope this helps.

CM

In article <352B9F61.7C33_at_maricopa.edu>,   young_at_maricopa.edu wrote:
>
> aa wrote:
> >
> > Can someone explain to me what is meant by consistent gets?
> > I know consistent gets + db Block reads = logical reads but what are
> > consistent gets?
> > TIA
> Basically, consistent gets are the number of blocks accessed by the
> SELECT statement (with no FOR UPDATE clause).
> --
> Kelly Young
> Database Administrator
> Maricopa Community Colleges
> young_at_maricopa.edu
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 09 1998 - 17:20:34 CDT