Re: dynamic views cosnstency, do they use UNDO?

  • From: amonte <ax.mount@xxxxxxxxx>
  • To: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • Date: Tue, 5 Sep 2006 08:37:59 +0200

Thanks Christian

Thanks for the link.

On 9/5/06, Christian Antognini <Christian.Antognini@xxxxxxxxxxxx> wrote:


> 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

Because the information in the V$ views is dynamic, read consistency is
not guaranteed for SELECT operations on these views.

HTH Chris

Other related posts: