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

Thread: Redo Logs

  1. 06-14-2001, 02:44 AM #1
    sudip's Avatar
    sudip
    sudip is offline Senior Member
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Unhappy

    Hi! All
    My database has 8 redo log groups and size of each member 100m(don't ask me why? I asked the same question to my DBA). Now log_buffer=100m, log_checkpoint_interval = 100m
    and log_checkpoint_timeout = 3600.
    Now in the alert.og file I find that It takes around i hour to complete a checkpoint. Is it a performance bottleneck. Will reducing the value of log_checkpoint_interval help?
    The alert.log cutting is as below
    ==================================================================
    Tue Jun 12 15:31:21 2001
    Beginning log switch checkpoint up to RBA [0x55.2.10], SCN: 0x0000.0007e036
    Thread 1 advanced to log sequence 85
    Current log# 5 seq# 85 mem# 0: /vol01/oradata/oraep1db/redo1c.log
    Current log# 5 seq# 85 mem# 1: /vol03/oradata/oraep1db/redo3d.log
    Tue Jun 12 16:33:11 2001
    Completed checkpoint up to RBA [0x55.2.10], SCN: 0x0000.0007e036
    ==================================================================

    Regards
    There Nothing You cannot Do, The problem is HOW.
    Reply With Quote Reply With Quote
  2. 06-14-2001, 02:56 AM #2
    ggnanaraj
    ggnanaraj is offline Senior Advisor
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    What is the database version u are running? 8 or 8i? The concept/values for LOG_CHECKPOINT_INTERVAL & LOG_CHECKPOINT_TIMEOUT vary depending on this.




    With regards.
    Reply With Quote Reply With Quote
  3. 06-14-2001, 03:08 AM #3
    sudip's Avatar
    sudip
    sudip is offline Senior Member
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    Hi!
    It's Oracle8i.
    There Nothing You cannot Do, The problem is HOW.
    Reply With Quote Reply With Quote
  4. 06-14-2001, 03:39 AM #4
    davidpan
    davidpan is offline Junior Member
    Join Date
    Dec 2000
    Posts
    22
    It is not a performance bottle.
    log_checkpoint_interval and log_check_timeout can increase the capability recovery.
    Reply With Quote Reply With Quote
  5. 06-14-2001, 03:59 AM #5
    sudip's Avatar
    sudip
    sudip is offline Senior Member
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    But what abt Checkpoint whichis happening for 1 hr.
    There Nothing You cannot Do, The problem is HOW.
    Reply With Quote Reply With Quote
  6. 06-14-2001, 05:03 AM #6
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    LOG_BUFFER = 100M ????

    Are you sure? 100M realy is an overkill! Even 1M is very large size on most systems.

    Also your specification of LOG_CHECKPOINT_INTERVAL = 100M is dubious. Are you sure it is set to that size? This parameter is expressed in number of *OS blocks*, not in db blocks. Hope your DBA is aware of this...
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Reply With Quote Reply With Quote
  7. 06-14-2001, 05:27 AM #7
    sudip's Avatar
    sudip
    sudip is offline Senior Member
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    YEs! Thats what I feel that everthing is a overkill and is a posible bottleneck
    HEre 's the alert .log cutting

    log_buffer = 104857600
    log_checkpoint_interval = 104857600
    log_checkpoint_timeout = 3600
    And Just have a look at the Checkpoint timing.

    Tue Jun 12 15:31:21 2001
    Beginning log switch checkpoint up to RBA [0x55.2.10], SCN: 0x0000.0007e036
    Thread 1 advanced to log sequence 85
    Current log# 5 seq# 85 mem# 0: /vol01/oradata/oraep1db/redo1c.log
    Current log# 5 seq# 85 mem# 1: /vol03/oradata/oraep1db/redo3d.log
    Tue Jun 12 16:33:11 2001
    Completed checkpoint up to RBA [0x55.2.10], SCN: 0x0000.0007e036

    Any ideas??
    There Nothing You cannot Do, The problem is HOW.
    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