Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

db block gets , current mode , Consistent gets, consistet mode

612530Aug 3 2008 — edited Aug 4 2008
Hi
When i tried to know about what exactly "db block gets" and "Consistent gets"
are, i ended up gettting really confused. some document say "db block gets" are
read in "current mode" and "consistent gets" are read in "consistent mode", but
there is not much information about the two modes, when i tried googling i couldnt
find much much about that, can some clearly explain(like a lay man kind of
explanation) me what they are all about.

whether they are good or bad for a query, in which scenarious we will get
more counts for "db block gets" and "consisten gets" and how to manage that.

Thank you
Maximus
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 1 2008
Added on Aug 3 2008
14 comments
2,681 views