- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Only half CPUs being fully utilized
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-12-2010 08:31 AM
тАО08-12-2010 08:31 AM
Re: Only half CPUs being fully utilized
I even looked at psrset and it looks like all cpus are just in the default grouping:
$ /usr/sbin/psrset
PSET 0
SPU_LIST 0 1 2 3 4 5 6 7
OWNID 0
GRPID 0
PERM 755
IOINTR ALLOW
NONEMPTY DFLTPSET
EMPTY FAIL
LASTSPU DFLTPSET
LDOM_LIST 0 1
RTE DISALLOW
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-12-2010 09:52 AM
тАО08-12-2010 09:52 AM
Re: Only half CPUs being fully utilized
My opinion, if the database is running slow, it does not mean that problem with the UNIX system. My advice check the database logs as well.
If your system having 8 CPU, it does not mean all 8 will be busy every time, it depends on the incoming request and load.
This is what I can think as of now.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-12-2010 10:29 PM
тАО08-12-2010 10:29 PM
Re: Only half CPUs being fully utilized
SYS could also mean the system is really busy providing the data for the database, blocking almost all I/O for other processes on the filesystem but showing 'activity' in top. (Glance does this better, especially when zooming in on processes or looking at syscalls.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-13-2010 01:34 AM
тАО08-13-2010 01:34 AM
Re: Only half CPUs being fully utilized
Could you provide some more details.
parstatus -V
vparstatus -V (if vpar exist)
sar -Muqc
sar -b
sar -v
sar -u
ioscan | grep -i processor
uname -r
Best Regds,
Ganesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-13-2010 02:08 AM
тАО08-13-2010 02:08 AM
Re: Only half CPUs being fully utilized
To confirm whether SIM is running use
#ps -eaf | grep -i wbem
If yes, login to SIM by http://
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-13-2010 07:43 AM
тАО08-13-2010 07:43 AM
Re: Only half CPUs being fully utilized
This means that only 4 processes are busy computing and the rest are either sleeping or waiting on I/O. You can't expect a single process to be split across multiple CPUs. Your DBA configures the number of available processors in Oracle and Oracle with adjust internal code to take advantage of the resources. But for a single thread of code, only one CPU will be used. If it uses 100% of that CPU, you cannot 'share' the load across 2 CPUs.
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-13-2010 07:49 AM
тАО08-13-2010 07:49 AM
Re: Only half CPUs being fully utilized
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-17-2010 07:20 AM
тАО08-17-2010 07:20 AM
Re: Only half CPUs being fully utilized
Your second top output, shows that also cpu 6 gets hammered, so I dont think the problem is the # of cpu "an sich".
However its not normal that oracle processes are spending that much time in 'system mode'.
Log a call with oracle support and see if they can find out which system calls are causing the oracle processes to spend that much time in system mode.
If oracle support doesnt come up with satisfying answers, log a performance case with hp support and a internal tool as kitrace should be able to find out what is going on.
Greetz,
Chris
PS. Installing the latest patchbundle should also be a good idea.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-17-2010 08:05 AM
тАО08-17-2010 08:05 AM
Re: Only half CPUs being fully utilized
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-12-2011 08:14 AM
тАО01-12-2011 08:14 AM
Re: Only half CPUs being fully utilized
I have a somewhat similar situation, but in my case, it is when I invoke the PL/SQL package dbms_stats.gather_table_stats with the degree parameter specifying parallel processing. Oracle proceeds to launch 72 processes, but they only run on 4 of the 8 CPUs. I enabled hyperthreading, and same results: the processes only run on 8 of the 16 CPUs! I've had installed the Oracle-recommended patches for 11.31, and same results. I have a ticket open with Oracle. I can do other queries that do use all the CPUs, but that particular command is using just half the CPUs.