LOG_CHECKPOINTS_TO_ALERT

Property	Description
Parameter type	Boolean
Default value	false
Modifiable	ALTER SYSTEM
Range of values	true | false
Basic	No

LOG_CHECKPOINTS_TO_ALERT lets you log your checkpoints to the alert file. Doing so is useful for determining whether checkpoints are occurring at the desired frequency.

Note:

1. Prior to Oracle9i this parameter was STATIC.

   Oracle generally advises this be set to TRUE as the overhead is negligible but the information in the alert log may be useful.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘LOG_CHECKPOINTS_TO_ALERT’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
log_checkpoints_to_alert	FALSE	TRUE	FALSE	IMMEDIATE	TRUE	FALSE	log checkpoint begin/end to alert file

Oracle initializatoin parameters