how to estimate size of archivelogs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: how to estimate size of archivelogs

Hybrid View

  1. #1
    Join Date
    Oct 2001
    Posts
    127
    How to estimate archivelogs generated per day on a database?

  2. #2
    Join Date
    Oct 2000
    Posts
    467
    the size of your archive logs depends on the size of your log buffer and when you make a log switch. To know your log size you have to estimate the volume of DMLS which generate redo info on your DB. Once you know that sizing is easy. You may also gather statistics from v$sysstat to check contention or waits.
    Vinit

  3. #3
    Join Date
    Oct 2001
    Posts
    127
    Thanks for the reply.I want to know if your do'nt really know how many DMLS are there ,can you estimates based on some statistics ,how much space or how many archivelogs will be generated per day.I mean a rough estimate.

  4. #4
    Join Date
    Oct 2000
    Posts
    467
    You can. The log buffer can be anywhere from 5 -50M depending on your resources and db size. As I said, you need to monitor stats once you've sized your log buffer.
    Vinit

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by vinit
    You can. The log buffer can be anywhere from 5 -50M depending on your resources and db size. As I said, you need to monitor stats once you've sized your log buffer.
    LOG_BUFFER 5-50M? Come on! 1M is often too much :-)
    You probbaly mean the log files?


  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Also, the size of log buffer has no impact on the amount of redo generated on the sistem whatsoever. The amount of daily generated archlogs is purely a function of the changes made on the database that day. It is not dependant on the size of log buffer nor on the size of the redo log files.

    [Edited by jmodic on 11-27-2001 at 05:34 AM]
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  7. #7
    Join Date
    Oct 2000
    Posts
    467
    Originally posted by julian
    Originally posted by vinit
    You can. The log buffer can be anywhere from 5 -50M depending on your resources and db size. As I said, you need to monitor stats once you've sized your log buffer.
    LOG_BUFFER 5-50M? Come on! 1M is often too much :-)
    You probbaly mean the log files?

    Yes..the log files indeed. Sorry about that.
    Vinit

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