Re: 12c RAC high CPU usage

  • From: Seth Miller <sethmiller.sm@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 30 Sep 2013 14:21:29 -0500

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@xxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


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


Other related posts: