Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Redo logs size

RE: Redo logs size

From: Shamsudeen, Riyaj <RS2273_at_att.com>
Date: Mon, 11 Jun 2007 13:56:30 -0500
Message-ID: <6A4102F59ECFA248B81F7D08F03179780126DB77@TBDCEXCH01.US.Cingular.Net>


I think, v$archived_log should give you that.  

select name, blocks*block_size from V$ARCHIVED_LOG  


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of rjamya Sent: Monday, June 11, 2007 1:51 PM
To: Oracle Discussion List
Subject: Redo logs size  

It is possible to find out using dictionary/v$ views how much the online redo log file contained when it was switched? i.e. it is possible to estimate/calculate mb of archive log generated per hour without doing calculations at os level?

version 9i and above. i have looked in the manuals and metalink, but didn't find any references. Perhaps i missed.  

Best regards
RJamya

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 11 2007 - 13:56:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US