RE: dynamic views cosnstency, do they use UNDO?

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Tue, 5 Sep 2006 00:52:48 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF6156BC@MSXVS04.trivadis.com>

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

Received on Mon Sep 04 2006 - 17:52:48 CDT