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

Thread: redo log size

  1. #1
    Join Date
    Jun 2000
    Posts
    104
    any body can tell how to find the appropriate size of redolog files,any formulae,
    can we increase the size after db creation.

  2. #2
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    It is suggested that you size the redo log files in a way that there are no more than 3-4 log switches per hour (at peak usage). Yes, you can increase the size of the redo log files by dropping/recreating them.
    alter database drop logfile group x;
    alter database add logfile group x ('location1', 'location2') size 50M;

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