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

Thread: Managing archive log size

Threaded View

  1. 09-30-2009, 01:25 AM #7
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Can the op please confirm you have 9gb redo log files really ?

    even if you have 9gb redo log files and say you have set parameter

    ALTER SYSTEM SET ARCHIVE_LAG_TARGET = 600 SCOPE=BOTH;
    This sets the maximum lag to 10 mins.




    regards
    Hrishy
    Last edited by hrishy; 09-30-2009 at 03:18 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width