Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Lite: Redo sequence# poll

Re: Lite: Redo sequence# poll

From: Jeremiah Wilton <jwilton_at_speakeasy.net>
Date: Mon, 11 Mar 2002 14:43:27 -0800
Message-ID: <F001.004250C0.20020311144327@fatcity.com>


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).
Received on Mon Mar 11 2002 - 16:43:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US