One should also look at the blog entry earlier in the month as well. = Also for those who have not found it http://www.orablogs.com/orablogs/ is an excellent site which gleans material from many Oracle bloggers. = It's where I saw the post on SMON and UNDO. Ian -----Original Message----- From: Kirtikumar Deshpande [mailto:kedeshpande@xxxxxxxxx]=20 Sent: Tuesday, April 26, 2005 6:52 AM To: MacGregor, Ian A.; oracle-l@xxxxxxxxxxxxx Subject: Re: SMON and Undo Thanks for sharing this, Ian. This is quite interesting indeed..=20 Tracing SMOM can reveal some 'interesting code' that maintains the = internal table sys.smon_scn_time used for Flashback Query feature in 9i.=20 Cheers! - Kirti=20 --- "MacGregor, Ian A." <ian@xxxxxxxxxxxxxxxxx> wrote: > http://doug.burns.tripod.com/oracle/index.blog?entry_id=3D3D1076486 >=20 > I find the above interesting because one doesn't expect Oracle to =3D > miscode something as basic to the database as this. It is also =3D > interesting that they were able to reproduce a problem such as this. >=20 > Ian MacGregor > Stanford Linear Accelerator Center > ian@xxxxxxxxxxxxxxxxx > -- > //www.freelists.org/webpage/oracle-l __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around=20 http://mail.yahoo.com=20 -- //www.freelists.org/webpage/oracle-l