Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Checkpoint process consuming a full CPU for the last 16 hours

Re: Checkpoint process consuming a full CPU for the last 16 hours

From: David Barbour <david.barbour1_at_gmail.com>
Date: Fri, 3 Aug 2007 13:30:03 -0400
Message-ID: <69eafc3f0708031030i33cb43e0mb3a10b8ec7b43141@mail.gmail.com>


Is this RAC or standalone? What flavor of UNIX? Anything in the alert log?

On 8/3/07, jurgen_mortier_at_amis.com <jurgen_mortier_at_amis.com> wrote:
>
>
> Hi,
>
> I have a production DB that has been restarted on last saturday, July 28th
> at 20h15 (by a senior collegue who's on vacation now).
> When I look at the top 10 processes in UNIX, a process called
> ora_ckpt_ORAP9 keeps popping up and it is running since July 28th.
> Is this a process that is supposed to run since the start of the DB ?
>
> I also seems to be consuming 1 out of 8 CPU's since I did the following:
> - adjusted the undo retention (Online) from 3600 to 2700 to see if this
> was
> reflected in the initDB.ora file (it wasn't, so all dynamic parameters
> that
> were adjusted before the reboot were reset)
> - adjusted the shared pool size from 1000M to 600M and the undo retention
> from 3600 to 1800.
>
> The reason I did this, is to return to a previous situation to investigate
> a performance issue.
> Is this a normal reaction of the system ?
>
> In the mean time I discussed this with an overseas collegue and learned
> that it is indeed the initDB.ora file that is taken into account because
> there is no spfile.
> But he doesn't know either if the checkpoint process should be running
> that
> intensely.
>
> Should I have restarted the DB for these changes ?
> Should I still do this now to get things back to normal again ?
>
> Regards
> Jürgen Mortier
>
> AMI Semiconductor - "Silicon Solutions for the Real World"
> NOTICE:
> This electronic message contains information that may be confidential or
> privileged. The information is intended for the use of the individual or
> entity named above. If you are not the intended recipient, please be aware
> that any disclosure, copying, distribution or use of the contents of this
> information is prohibited. If you received this electronic message in error,
> please notify the sender and delete the copy you received.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 03 2007 - 12:30:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US