redo log
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: redo log

  1. #1
    Join Date
    Apr 2001
    Posts
    46
    Hi everybody

    The size in v$log (BYTES) shows the allocated size for each redo log file.
    How do I know the used size in a redo log file ( in Oracle BLOCK or in OS).
    yt

  2. #2
    Join Date
    Jun 2000
    Location
    chennai,tamil nadu,india
    Posts
    159
    I think you have to link v$logmnr_contents and v$session and can find it.

  3. #3
    Join Date
    Jun 2001
    Posts
    29
    YT

    Oracle will fill the redo log before switching. If a manual log switch is performed, the redo log may not be 'full'. If you are archiving, the archived redo log will be the actual size of the redo, not the size of the log. This is probably your best indicator of actual redo generated.

    In v$sysstat, the stat 'redo size' is the number of bytes placed in the log buffer. If you divided this number by the number of logs generated since instance startup, you will get a very rough idea. However, unless you performed a complete log switch at shutdown and all the entries had been written to the redo logs and another switch had occurred, your estimation will be off.
    Daniel W. Fink
    oracledba@ix.netcom.com

  4. #4
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    If you want to know this to figure out how much Redo is generated every day (or hour) then the best bet will be to look into the Alert file for all the Normal Log switches (switches that were not caused manually)

    Count the number for a reasonably long period (a week or a month ) and then devide by the number of days in that peiod to get a rough idea of the redo amount per day.

    For accurate results, this assumes that the instance was not shutdown during that period.

    - Rajeev
    Rajeev Suri

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width