How to estimate archivelogs generated per day on a database?
Printable View
How to estimate archivelogs generated per day on a database?
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.
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.
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 :-)Quote:
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.
You probbaly mean the log files?
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]
Yes..the log files indeed. Sorry about that.Quote:
Originally posted by julian
LOG_BUFFER 5-50M? Come on! 1M is often too much :-)Quote:
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.
You probbaly mean the log files?