- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Processor affinity
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
Forums
Discussions
Discussions
Discussions
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
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
07-17-2002 01:49 AM
07-17-2002 01:49 AM
Processor affinity
I have oracle 8i running on an A500 HP-UX 11i server, we seem to have a CPU bottleneck on the system which is slowing oracle processes.
However, it looks like the Oracle processes will only bind to a single processor, this system has 2 processors, and one of them is almost always at 100% when running queries, the other is barely used at all.
The PSET software is NOT installed on this system, and a mpsched -qp on all of the Oracle server processes shows no binding.
Can anyone help explain why Oracle processes are behaving like this?
I know that an mpctl call by the Oracle software can do this, but I have no way to tell if this is the case.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2002 05:51 AM
07-17-2002 05:51 AM
Re: Processor affinity
http://docs.hp.com/hpux/onlinedocs/B3782-90716/00/00/34-con.html
HTH
mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2002 11:24 PM
07-17-2002 11:24 PM
Re: Processor affinity
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-18-2004 06:25 AM
02-18-2004 06:25 AM
Re: Processor affinity
I wonder if you find out what happne to your server...??? it seems like I have similar problem running Oracle9i on HPUX 11i on a RP7410server...
Please help...
Thanks,
Ed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-18-2004 06:35 AM
02-18-2004 06:35 AM
Re: Processor affinity
- run more processes.
- rewrite the application to use threads.
A thread is a mini-process which is created and monitored by the main process. An easy example of a threaded application is your favorite browser. While things are downloading, you can change options, start something printing, even change your mind and go to another URL. The overall browser code is monitoring events (mouse movements, clicks, keystrokes, etc) and starts an internal routine that performs this subtask.
So until Oracle is configured to run threaded (or if it is already, it apparently doesn't have more than one long term task to accomplish), you'll see just one processor being used.
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-18-2004 08:07 PM
02-18-2004 08:07 PM
Re: Processor affinity
Use top to work out which processes you want to move, then use the program below to move them.
/* set_cpu.c assigns a process ($1) to cpu($2) */
/* note that cpus are numbered 0,1,2,3... */
#include
#include
int main(int argc, char *argv[])
{
int pid, cpu, numcpus;
if (argc<2) return 10;
if ((pid=atoi(argv[1])) < 0) return 11;
if ((cpu=atoi(argv[2])) < 0) return 12;
/* find out how many cpus are installed */
numcpus = mpctl(MPC_GETNUMSPUS,0,0);
/* if numcpus=4, cant request cpu 4, since numbered 0,1,2,3 */
if (cpu >= numcpus) return 13;
/* now try to assign the pid to the cpu and
return its number */
return mpctl(MPC_SETPROCESS,cpu,pid);
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-19-2004 01:30 AM
02-19-2004 01:30 AM
Re: Processor affinity
it looks like the Oracle processes
this sounds like plural too me!
However, how many oracle processes and how much do they use the one cpu?
Are the clients local or remote?
Michael