Oracle Blogs SMON and Undo
- From: "MacGregor, Ian A." <ian@xxxxxxxxxxxxxxxxx>
- To: "Kirtikumar Deshpande" <kedeshpande@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 26 Apr 2005 09:34:01 -0700
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
> --
> http://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
--
http://www.freelists.org/webpage/oracle-l
Other related posts:
- » Oracle Blogs SMON and Undo