> For each log switch there is one record count in gv$loghist view. So
> in a given day
> if I have 5 records in this view then there 5 log switch happened.
> Count(*)=5
> Each Log file size=100MB
> So total redo generated= 5*100=500MB
>
> So I have to MULTIPLY.
>
> Yes. I am just trying to calculate approx size(ignoring manual log
> switch and db shutdown,etc) to get an estimate.
>
> Correct me If I am wrong.
>
Nope, you're right. Time to go to bed... :-)
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Mar 13 2005 - 22:55:01 CST
