| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: log_checkpoint_interval - Any Critically High Value on 8i ?
Naveen
There was a Database-wide slowdown in execution of ALL Processes with 1000 user processes doing Mostly OLTP Operations .
We Reset the Value Back from 10,00,000 to 4,70,000 & performance came back to Normal
We never tried such a Value in Oracle 8i version
NOTE - This was Done on a Everyday Running Production Database whose performance levels are well known
Thanks
-----Original Message-----
Sent: Tuesday, October 08, 2002 6:34 PM
To: Multiple recipients of list ORACLE-L
log_checkpoint_interval is specified in number of OS Blocks. Depending upon the size of ur OS Block it will force a checkpoint after that many number of bytes written in the redo buffers.
Normally it should be a divisor of the redo log size, means for 500MB it should be 1MB, 2MB, 5MB but not 7 MB because 500/7 doesn't give an integer value.
Setting it to more than the size of the redo-logs, gives no advantage, it will only ir-regularize the checkpoints.
Usually, increasing the checkpoint interval increases the performance by reducing the checkpoint frequency.
There is no upper limit, but I don't know what will happen if u set it to zero.
What was the exact performance problem that u faced?
Regards
Naveen
-----Original Message-----
Sent: Tuesday, October 08, 2002 4:09 PM
To: Multiple recipients of list ORACLE-L
Qs log_checkpoint_interval - Is there any Upper Limit to Setting it's Value on Oracle 8.1.7 ?
NOTE - On a Hybrid 150 GB Database (Oracle 7.3.4) on setting increasing it's
Value from
4,70,000 to 10,00,000 we had faced a Huge performance problem & had Scaled it
Down back
to 4,70,000
NOTE - Online Redo Logs were of Size 500 MB Each
Qs Does Setting log_checkpoint_timeout to 0 Disable the Same ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 08 2002 - 08:33:26 CDT
 |
 |