Dynamic: ALTER SYSTEM
Range of values
0 to unlimited
Real Application Clusters
Multiple instances can have different values.
LOG_CHECKPOINT_TIMEOUT specifies (in seconds) the amount of time that has passed since the incremental checkpoint at the position where the last write to the redo log (sometimes called the tail of the log) occurred. This parameter also signifies that no buffer will remain dirty (in the cache) for more than integer seconds.
Specifying a value of 0 for the timeout disables time-based checkpoints. Hence, setting the value to 0 is not recommended.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9078678/viewspace-45098/，如需转载，请注明出处，否则将追究法律责任。