Re: dynamic views cosnstency, do they use UNDO?

Thanks Christian

Thanks for the link.

On 9/5/06, Christian Antognini <Christian.Antognini_at_trivadis.com> wrote:
>
> Alex
>
> > If let's say it takes 10 seconds does Oracle guarantee the values I
> > am seeing are from 10 seconds ago? I am pretty sure undo is not used
> > for memory structures or wrong?
>
> For the fine manual
> http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/dynvie
> ws_1001.htm#sthref3418...
>
> <quote>
> Because the information in the V$ views is dynamic, read consistency is
> not guaranteed for SELECT operations on these views.
> </quote>
>
>
> HTH
> Chris
>

--
http://www.freelists.org/webpage/oracle-l