Re: Lite: Redo sequence# poll

My stats:

Longest time since last restart (uptime) - 08/30/2001 (v$instance - startup_time)

Oldest database - 11/05/1999 (v$database - created)

High SCN - 5551718526045

All not very impressive. Who has better?

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Mon, 11 Mar 2002, Jeremiah Wilton wrote:



> Since people with undersized logfiles will come out on top, how about


> comparing current SCNs instead?

> 

> select max(ktuxescnw * power(2, 32) + ktuxescnb) from x$ktuxe;

> 

> Also longest time since last startup would be interesting to see.

> 

> Thanks to Steve Adams and http://www.ixora.com.au for the query.

> 

> On Mon, 11 Mar 2002, Hand, Michael T wrote:

> 

> > Well it looks like our production OLTP database will be breaking into the

> > 6-digit range for redo sequence# this year, and I had a little idle time.

> > This got me thinking about where some other folks are at, so here it goes:

> > 

> > Redo sequence#:  89689     Cummulative Wr: 11.12Tb (assumes each Redo log is

> > full at log switch)

> > Uptime since database creation / resetlog:  ~3.5yrs


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).