??: [SPAM] dynamic views cosnstency, do they use UNDO?
- From: "Serol_Luo \(BJ\)" <Serol_Luo@xxxxxxxxx>
- To: <ax.mount@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 5 Sep 2006 08:19:02 +0800
Some test can be built like below. Begin For I in (select * from v$session ) loop dbms_lock.sleep(...); --- Fetch data, do something end loop; ============================== Regards. Serol Luo, From Peking,China Or call me RollingPig http://rollingpig.itpub.net -----????----- ???: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]?? amonte ????: 2006?9?5? 6:14 ???: oracle-l@xxxxxxxxxxxxx ??: [SPAM] dynamic views cosnstency, do they use UNDO? ???: ? Hi Since v$ views based on x$ are memry structures I guess there is no guarantee that they would give a consistent view correct? For example in some busy systems, for example a 2500 users CRM system running joins of v$ views is time consuming, for example if I try to join v$sesstat with v$session it takes really a while. 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? I Cant seem to find a easy way to test this. TIA Alex
Other related posts:
- » ??: [SPAM] dynamic views cosnstency, do they use UNDO?