Re: Building app around Flashback Versions Query

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 2 Dec 2005 08:02:15 +0000 (UTC)
Message-ID: <dmov27$m3c$1@nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com>

I think you may be thinking of the SMON_SCN_TIME table which Oracle uses to convert from timestamps to SCNs if you use the 'as of timestamp' form.

This is limited to a rolling 1440 entries (per instance) and gets updated every five minutes - which means you can get five days of timestamps in a non-stop database. (or 10 days if you shutdown from 6 pm to 6 am ;)

The last time I looked, the limit hadn't changed in 10g, but Oracle had implemented a change that improved the accuracy of the conversion from time to SCN - the earlier versions were only accurate to that five minute boundary.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle: Fundamentals

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 4th Nov 2005

<bdbafh_at_gmail.com> wrote in message 
news:1133475997.052657.130690_at_g49g2000cwa.googlegroups.com...


>I don't have the info in front of me, but in 9.2 I believe that the

> controlfile_keep_time limited the range to 5 days in the past. This may

> be a non-issue in 10g R1.

>

> -bdbafh

>

Received on Fri Dec 02 2005 - 02:02:15 CST