Re: Check Point Process

From: Jurijs Velikanovs <j.velikanovs_at_gmail.com>
Date: Mon, 8 Jun 2009 02:14:55 +1000
Message-ID: <d6f0def50906070914y76d3ddb3tfbc146fd9ed20110_at_mail.gmail.com>

If I am not mistaken this parameter is a history nowadays. It has been obsoleted in 8i or something.
Back to the original question: Is the process is always up and does it make scene to include it in DB up check? - A - Instead of checking processes I would create a no privileges DB user and try to connect and select * from dual. - B - If you wish to check DB status via checking processes on OS level I think PMON or SMON check would be significant. If any of those goes down DB is "KAPUTT".

Yury

On Mon, Jun 8, 2009 at 1:56 AM, David
Ballester<ballester.david_at_gmail.com> wrote:
>
>
> 2009/6/7 David Ballester <ballester.david_at_gmail.com>
>>
>>
>> 2009/6/7 harshan eppuram <harshan.eppuram_at_gmail.com>
>>>
>>> Dear NIzar,
>>>
>>> DBA decides whether or not to run ckpt process. If DBA want ckpt process
>>> to be runing he/she needs to set CHECKPOINT_PROCESS to TRUE init.ora file.
>>> Incase you are running instance with this parameter on then there is a point
>>> in checking for that ckpt process.
>>>
>>> Hope I am clear.
>>> Regards,
>>> Harshan
>>
>> checkpoint_process enables another chkp process to help in the process of
>> checkpoint, if you have a lot of datafiles, but at least one chkp is always
>> running. When you may have an useful oracle/server without checkpointer?
>>
>>
>>
>> D.
>
> And of course, this parameter is obsolete in 8i or greater release
>
>
>
>

-- 
Jurijs
+371 29268222 (+2 GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
--
http://www.freelists.org/webpage/oracle-l

Received on Sun Jun 07 2009 - 11:14:55 CDT