Re: HELP with enabling CKPT process using checkpoint_process parameter in the init.ora

Unknown User <unknown_at_unknown.com> wrote in message news:<r7ulltg0dtgitjb4m303bu6236auvbv8n5_at_4ax.com>...
> Hi,
>
> I have Personal Oralce8i 8.1.7 on Windows 2000 Pro SP2.
> According to Oracle8i Documentation,
>
> http://technet.oracle.com/doc/server.815/a67772/manproc.htm#1854
>
> Starting the Checkpoint Process
>
> If the Checkpoint process (CKPT) is not enabled, the Log Writer process (LGWR)
> is responsible for updating the headers of all control files and data files to reflect
> the latest checkpoint. To reduce the time necessary to complete a checkpoint,
> especially when a database is comprised of many data files, enable the CKPT
> background process by setting the CHECKPOINT_PROCESS parameter in the
> database's parameter file to TRUE. (The default is FALSE.)
>
> I added the following line in my init.ora file.
>
> checkpoint_process = true # enables CKPT process
>
> The following error message was received.
>
> SQL> shutdown transactional
> Database closed.
> Database dismounted.
> ORACLE instance shut down.
> SQL> startup open
> LRM-00101: unknown parameter name 'checkpoint_process'
> ORA-01078: failure in processing system parameters
> SQL>
>
> What am I missing or doing wrong? Thank you for your help.

This a documentation bug. The parameter is obsolete as from 8.0 and beyond as the check_point_process is automatically started.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Mon Jul 23 2001 - 13:11:01 CEST