Re: Oracle in an AIX LPAR

From: Rich Jesse <rjoralist3_at_society.servebeer.com>
Date: Wed, 4 Mar 2015 10:16:25 -0600 (CST)
Message-ID: <fcea7c2b14f32444ab97d857e34d9ed3.squirrel_at_society.servebeer.com>



Hey John,

> This is power7 in a dedicated LPAR.

An LPAR is IBM's term for a VM. So, is there just one LPAR on your POWER7? I'd think there'd also be at least 2 more for VIOs, but that's stretching my knowledge limits...

SMT also comes into play here. By default, the LPAR should be using SMT4, which means that 1 virtual CPU core will be shown as 4 logical CPUs. You should be able to see this in the "p" screen of nmon.

You mentioned "1 thread per CPU". It sounds like you might be thinking of Oracle on Windows? If so, Oracle doesn't run the same in Unix/Linux. The background processes will be exposed as individual processes in AIX instead of Windows threads in a single process.

Which Oracle process shows at 50% (e.g. using the "u" screen in nmon)? That could give a big clue...

Let us know!

Rich

> On Wed, Mar 4, 2015 at 9:49 AM, Stefan Koehler <contact_at_soocs.de> wrote:
>
>> >> we see that Oracle appears to be using only 1 thread per CPU almost all
>> the time.
>> You mean one vCPU = one thread, right? The CPU usage can also be shown as
>> 50%, but it is not 50% in reality - it depends on the used entitlement per
>> vCPU.

[snip]

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 04 2015 - 17:16:25 CET

Original text of this message