Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Newbie question on checkpointing

Newbie question on checkpointing

From: Juan Carlos <jc_va_at_hotmail.com>
Date: Sun, 27 Jun 1999 18:36:30 -0700
Message-ID: <7l695a$f3j$1@bgtnsc01.worldnet.att.net>


I am running 8.0.5 on linux at home. It let it run during the day just to help me study for the OCP exam. I notice in the alert log a horrendous amount of checkpointing activity. Using the tail -f command on the alert log, it appears almost constant. Can anyone tell me why, especially when there is so little activity? A log excerpt and relevant parameters below. I was expecting to see a checkpoint every 30 minutes (1800 secs.) Thanks.

SVRMGR> show parameter checkpoint

NAME                                TYPE    VALUE
----------------------------------- ------- ------------------------------
db_block_checkpoint_batch           integer 8
log_checkpoint_interval             integer 10000
log_checkpoint_timeout              integer 1800
log_checkpoints_to_alert            boolean TRUE


Sun Jun 27 18:14:18 1999
Beginning interval checkpoint up to RBA [0x26c.b.10], SCN: 0x0000.0001af45 Completed checkpoint up to RBA [0x26c.b.10], SCN: 0x0000.0001af45 Beginning interval checkpoint up to RBA [0x26c.b.10], SCN: 0x0000.0001af46 Completed checkpoint up to RBA [0x26c.b.10], SCN: 0x0000.0001af46 Beginning interval checkpoint up to RBA [0x26c.b.10], SCN: 0x0000.0001af47 Completed checkpoint up to RBA [0x26c.b.10], SCN: 0x0000.0001af47 Beginning interval checkpoint up to RBA [0x26c.b.10], SCN: 0x0000.0001af48 Completed checkpoint up to RBA [0x26c.b.10], SCN: 0x0000.0001af48 Beginning interval checkpoint up to RBA [0x26c.b.10], SCN: 0x0000.0001af49 Completed checkpoint up to RBA [0x26c.b.10], SCN: 0x0000.0001af49

etc.
etc.
etc........thousand of lines......






Received on Sun Jun 27 1999 - 20:36:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US