DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Database size & Logfile size relation

  1. #1
    Join Date
    Aug 2000
    Posts
    30
    Hi friends,

    What is the relation between Database size and logfile size.
    Is there any ratio? If somebody can tell their database size with number of datafile and logfile in detail, i will be much happier.

    Thanks in Advance
    Nehruji. R.


  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Logfile size depends on transaction volume and size.

    In a 300G database, with about 100 concurrent OLTP users, I have 16 log files of 32M each.
    Jeff Hunter

  3. #3
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    there is no easy formula for this. from my 2 production databases:
    Database 1: 14G used, 10-15 concurrent users.
    3 redo logs of 250M each

    Database 2: 5G used, 100 concurrent users.
    3 redo logs of 15M each

    Both database turn over a redo log about once an hour. As you can see, there is little correlation.

    fortunately this is easy to remedy if your redolog turn over too quickly (i like to see logs turn over every 60-90 minutes during normal activity). You can do this online with an ALTER DATABASE command. Just be *very* careful about deleting the old under/over-sized files and make a backup of your controlfile if you're not doing a database backup soon.

    D.

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