Oracle Blogs SMON and Undo

From: MacGregor, Ian A. <ian_at_slac.stanford.edu>
Date: Tue, 26 Apr 2005 09:34:01 -0700
Message-ID: <7F24308CD176594B8F14969D10C02C6C3B7F96@exch-mail2.win.slac.stanford.edu>

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_at_yahoo.com]=20 Sent: Tuesday, April 26, 2005 6:52 AM
To: MacGregor, Ian A.; oracle-l_at_freelists.org 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_at_slac.stanford.edu> 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_at_slac.stanford.edu
    > --
    > 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

Received on Tue Apr 26 2005 - 12:38:22 CDT