-
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.
-
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.
-
There Nothing You cannot Do, The problem is HOW.
-
It is not a performance bottle.
log_checkpoint_interval and log_check_timeout can increase the capability recovery.
-
But what abt Checkpoint whichis happening for 1 hr.
There Nothing You cannot Do, The problem is HOW.
-
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?
-
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.
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
|