Link to home
Create AccountLog in
Avatar of sventhan
sventhanFlag for United States of America

asked on

IBM AIX LPAR| how to find the allocated CPUs to a database

Hi -

I would like to find the no of CPUs allocated to a particular database. The following is the OS information. This has 16 cores/cpus but the system people are telling me that we've only using 7 CPU for a particular DB. How can I confirm this? Thanks.sve

$ prtconf -k
Kernel Type: 64-bit
$ prtconf
System Model: IBM,8205-E6B
Processor Type: PowerPC_POWER7
Processor Implementation Mode: POWER 7
Processor Version: PV_7_Compat
Number Of Processors: 16
Processor Clock Speed: 3550 MHz
CPU Type: 64-bit
Kernel Type: 64-bit
LPAR Info: 6 dbname
Memory Size: 160768 MB
Good Memory Size: 160768 MB
Console Login: enable
Auto Restart: true
Full Core: false
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Avatar of sventhan

ASKER

Its using Logical Partition (LPAR). Its using only subset of hardware resources not all the available ones.
So is this question now how to configure LPAR/AIX?
No. This is already configured on POWER 7 based system. I wanted to identify how many dedicated CPUs are allocated to a Particular DB as we're running multiple DBs on this server.
>>identify how many dedicated CPUs are allocated to a Particular DB as we're running multiple DBs on this server.

Sorry I can't help with that.
Please run

lparstat -i

What you see with prtconf as "Number Of Processors" corresponds to "Online Virtual CPUs" of lparstat.
These are virtual processors, which the hypervisor can map to 0.1 - 1 real CPUs, depending on these configuration options:

Type: Shared / Mode: Uncapped - The maximum number of useable CPUs is equal to 10 x "Entitled Capacity" or "Online Virtual CPUs", whichever value is smaller.

Type: Shared / Mode: Capped - The maximum number of useable CPUs is equal to "Entitled Capacity"

Type: Dedicated - The number of useable CPU's is fixed to "Entitled Capacity".

You can also post the output of "lparstat -i" so I can have a look at your settings.

Please note that the above settings determine the number of CPUs useable by the server as a whole. How many CPUs a prticular DB running on that server can use might be subject to restrictions internal to Oracle, like this CPU_COUNT parameter in Oracle's SPFILE.
If you're not using WPAR there is no OS way to limit the number of CPUs available to a particular application (DB) on the server.

Check with

lswpar -L

if there are Workload partitions.

If there are, search the partition in question and look for "CPU Shares".
Here is little more info....  Thanks for looking into this.

$ lparstat -i
Node Name                                  : BOSTON1
Partition Name                             : BOSPAR1
Partition Number                           : 6
Type                                       : Shared-SMT-4
Mode                                       : Capped
Entitled Capacity                          : 9.00
Partition Group-ID                         : 32774
Shared Pool ID                             : 0
Online Virtual CPUs                        : 16
Maximum Virtual CPUs                       : 30
Minimum Virtual CPUs                       : 2
Online Memory                              : 160768 MB
Maximum Memory                             : 204800 MB
Minimum Memory                             : 4096 MB
Variable Capacity Weight                   : 0
Minimum Capacity                           : 1.00
Maximum Capacity                           : 15.00
Capacity Increment                         : 0.01
Maximum Physical CPUs in system            : 16
Active Physical CPUs in system             : 16
Active CPUs in Pool                        : 16
Shared Physical CPUs in system             : 16
Maximum Capacity of Pool                   : 1600
Entitled Capacity of Pool                  : 1530
Unallocated Capacity                       : 0.00
Physical CPU Percentage                    : 56.25%
Unallocated Weight                         : 0
Memory Mode                                : Dedicated
Total I/O Memory Entitlement               : -
Variable Memory Capacity Weight            : -
Memory Pool ID                             : -
Physical Memory in the Pool                : -
Hypervisor Page Size                       : -
Unallocated Variable Memory Capacity Weight: -
Unallocated I/O Memory entitlement         : -
Memory Group ID of LPAR                    : -
Desired Virtual CPUs                       : 16
Desired Memory                             : 160768 MB
Desired Variable Capacity Weight           : 0
Desired Capacity                           : 9.00
Target Memory Expansion Factor             : -
Target Memory Expansion Size               : -
Power Saving Mode                          : Disabled
$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri May 17 09:25:18 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter cpu

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cpu_count                            integer     64
parallel_threads_per_cpu             integer     2
resource_manager_cpu_allocation      integer     64
SQL>
ASKER CERTIFIED SOLUTION
Avatar of woolmilkporc
woolmilkporc
Flag of Germany image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thank you so much.