Re: Lite: Redo sequence# poll

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.

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

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).