RE: Amount of redo

Hi, I am highly thankful for u replies as a result i was able to take imp. decission. Pawan -Original Message- Sent: Sunday, August 18, 2002 3:38 PM To: Multiple recipients of list ORACLE-L I sit corrected. Yechiel Adar Mehish - Original Message - To: Multiple recipients of

Re: Amount of redo

I sit corrected. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 4:43 PM > yechiel, > > I didn't miss the comment, it's not relevant. Archived logs are merely > copies of redo logs that have been fi

Re: Amount of redo

yechiel, I didn't miss the comment, it's not relevant. Archived logs are merely copies of redo logs that have been filled. Whether or not archiving is turned on, redo logs get filled and reused. Oracle tracks the log switches no matter what mode you are in, it just doesn't make the copy of the re

Re: Amount of redo

ist ORACLE-L <[EMAIL PROTECTED]> .il> cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject

Re: Amount of redo

Hello I do not think that you can estimate the amount of disk space required for archive log without turning archive log on and checking each day to see how much space you already used. To all who replied: I think that you missed his comment that currently he is NOT working with archive log on.

Re: Amount of redo

multiply the size of one of your redo logs by the number of log switches (from the alert log) over the time period. It's not completely accurate but it will give you a pretty good starting point for sizing. --- Pawan Dalmia <[EMAIL PROTECTED]> wrote: > > Hi List, > > I want to put my databse i

Re: Amount of redo

Querying V$LOG_HISTORY should help, but it will only tell you how many log switches occurred. You can get a good ballpark-estimate figure by counting the rate of log switches per day and multiplying by the size of your (largest) online redo log files. In SQL*Plus: column mb new_value V_MB

RE: Amount of redo

Try this little query: Number of Log Files per Hour (Oracle 8i) select to_char(first_time,'-MM-DD Month (Day)') day, to_char(sum(decode(substr(to_char(first_time,'hh24'),1,2),'00',1,0)),'') "00:00", to_char(sum(decode(substr(to_char(first_time,'hh24'),1,2),'01',1,0)),'') "01:00"

RE: Amount of redo

Day 0 Initial = SELECT max(sequence#) from v$log; Day 7 Final = SELECT max(sequence#) from v$log; Final-Initial * Log_File_Size = amount of redo generated in a week HTH Naveen -Original Message- Sent: Wednesday, August 14, 2002 5:39 PM To: Multiple recipients of list ORACLE-L Hi Li

Re: Amount of redo

V$LOG_HISTORY "Pawan Dalmia"