CKPT process started when checkpoint_process=false

From: Calvin Cheong <ccheong_at_letterbox.com>
Date: Wed, 18 Nov 1998 09:49:56 GMT
Message-ID: <3652973c.32441928@news.pacific.net.sg>

Hi

Oracle7 server 7.3.3.5.1
HPUX 10.20 Problem: CKPT process is started although checkpoint_process parameter is set to false. Why? (See capture below). Any help is appreciated. Thanks

Oracle Server Manager Release 2.3.3.0.0 - Production

Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.

Oracle7 Server Release 7.3.3.5.1 - Production Release With the distributed and parallel query options PL/SQL Release 2.3.3.5.1 - Production

SVRMGR> connect internal
Connected to an idle instance.
SVRMGR> startup
ORACLE instance started.

Total System Global Area       3036924 bytes
Fixed Size                       38980 bytes
Variable Size                  2580152 bytes
Database Buffers                409600 bytes
Redo Buffers                      8192 bytes

Database mounted.
Database opened.

SVRMGR> !ps -ef | grep MARS

  oracle 14858     1  0 17:13:07 ?         0:00 ora_lgwr_MARS
  oracle 14850 14849  0 17:13:01 ?         0:00 oracleMARS

(DESCRIPTION=(LOCAL=Y
ES)(ADDRESS=(PROTOCOL=beq)))

  oracle 14867 14866  1 17:13:19 ttyq2     0:00 grep MARS
  oracle 14866 14849  1 17:13:19 ttyq2     0:00 sh -c /usr/bin/ksh -c

"ps -ef |
grep MARS^J"

  oracle 14854     1  0 17:13:07 ?         0:00 ora_dbwr_MARS
  oracle 14852     1  0 17:13:07 ?         0:00 ora_pmon_MARS
  oracle 14856     1  0 17:13:07 ?         0:00 ora_arch_MARS
  oracle 14860     1  0 17:13:07 ?         0:00 ora_ckpt_MARS
  oracle 14862     1  0 17:13:07 ?         0:00 ora_smon_MARS
SVRMGR> show parameter checkpoint
NAME                                TYPE    VALUE
----------------------------------- -------
------------------------------
checkpoint_process                  boolean FALSE

db_block_checkpoint_batch           integer 8

log_checkpoint_interval             integer 31720

log_checkpoint_timeout              integer 0

log_checkpoints_to_alert            boolean FALSE

SVRMGR> Received on Wed Nov 18 1998 - 03:49:56 CST