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