Consistent gets – How Many? This is an off-site link.  Please review our Terms of Service for additional information.

(Thomas Saviour) When you execute an SQL – why there is a difference in Consistent gets on the same set of data for same SQL. For any SELECT query, oracle need to prepare the consistent data in the buffer cache using undo records then forward the data the requesting session as of a specific SCN.

Read this article...

comments powered by Disqus