Re: 12c RAC high CPU usage

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Mon, 30 Sep 2013 14:21:29 -0500
Message-ID: <CAEueRAXrCWPwdn5Mw9iO5dPJQ-kSiuvf8NCUPk73fXzJTtAijQ_at_mail.gmail.com>

Sanjay,
Make sure you have disabled Transparent Huge Pages.

https://blogs.oracle.com/linux/entry/performance_issues_with_transparent_huge

Seth

On Mon, Sep 30, 2013 at 1:22 PM, Sanjay Mishra <smishra_97_at_yahoo.com> wrote:

> Hi
> I had built the two node RAC using Virtual Box on Dell 2970 with 4G memory
> to each Node VM.
>
> when I tried to create Database, it basically hang at one point and stayed
> there for almost a day and put so much load in the server with topmost been
> gipcd.bin, lms, vtkm processes.
>
> I then finally cancelled and created the scripts and ran it and it created
> the database but after almost more than 18hr.
>
> Now as soon as I start the database, it shoots the CPU and not even able
> to logon to the server. I saw some site to use the following as mentioned
> by few sites but it just move the vtkm/lms process to low priotity but
> gipcd.bin is on high and system Run queue goes to 30+
>
> As soon as Database is stopped, the load/run queues reduce to almost 99%.
>
> selectksppstvl fromx$ksppi join x$ksppcv
> using(indx)whereksppinm='_high_priority_processes';KSPPSTVL
> --------------------------------------------------------------------------------LMS*|VKTM
>
> alter system set"_high_priority_processes"=''scope=spfile;
> TIA
>
> Sanjay
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Sep 30 2013 - 21:21:29 CEST