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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).