RE: Redolog size question?

[Cary Millsap]

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, Aug 16 Chicago - Miracle Database Forum, Sep 20–22 Middlefart Denmark - 2003 Hotsos Symposium on Oracle® System Performance, Feb 9–12 Dallas -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jonny Delmont Sent: Wednesday, July 31, 2002 7:54 AM To: Multiple recipients of list ORACLE-L Subject: Redolog size question?   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   Get a bigger mailbox -- choose a size that fits your needs. http://uk.docs.yahoo.com/mail_storage.html