RE: Redolog size question?

This is how much redo has been generated. You'll probably find (I think it's v$thread) that you've switched redo logs about 221 times (probably more) since your instance startup.  

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- NCOAUG Training Day <http://www.darc.com/ncoaug/> , Aug 16 Chicago

• Miracle Database Forum <http://www.miracleas.dk> , Sep 20-22 Middlefart Denmark
• 2003 Hotsos Symposium <http://www.hotsos.com> on OracleR System Performance, Feb 9-12 Dallas

-----Original Message-----
Delmont
Sent: Wednesday, July 31, 2002 7:54 AM
To: Multiple recipients of list ORACLE-L  

Hi Gurus,

Can some one explain me about my redo size here please? - my redo files size are 50M and the query below shows me 11Gb.

SQL> select name,value from v$sysstat
  2 where name in ('redo size', 'physical reads', 'db block gets')   3 /

NAME                                        VALUE
-------------------- ----------------------------
db block gets                          92,422,816
physical reads                        378,518,865
redo size                          11,613,542,316

Many thanks in advance.

Jonny  

<http://uk.yahoo.com/mail/tagline_xtra/?http://uk.docs.yahoo.com/mail_st orage.html> Get a bigger mailbox -- choose a size that fits your needs.  

<http://uk.yahoo.com/mail/tagline_xtra/?http://uk.docs.yahoo.com/mail_st orage.html> http://uk.docs.yahoo.com/mail_storage.html

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cary Millsap
  INET: cary.millsap_at_hotsos.com

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