Re: CKPT process started when checkpoint_process=false

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 18 Nov 1998 13:57:03 GMT
Message-ID: <3654d1d2.2958734@192.86.155.100>

A copy of this was sent to ccheong_at_letterbox.com (Calvin Cheong) (if that email address didn't require changing) On Wed, 18 Nov 1998 09:49:56 GMT, you wrote:

>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
>

this is a documentation bug.

...
sets checkpoint_process = false in init.ora but ckpt process still starts in 2 out of three of his databases. Has just upgraded them to 7.3.3 Doc bug 501513 states that The checkpoint process will be started if ANY of the following are true:

checkpoint_process = true
large db_files (=> 50)
large db_block_buffers (>= 10000)
...

In Oracle8, ckpt is always true regardless -- there is no init.ora parameter checkpoint_process anymore...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Nov 18 1998 - 07:57:03 CST