- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle / CPU usages
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
тАО03-02-2009 08:05 AM
тАО03-02-2009 08:05 AM
Oracle / CPU usages
cpu %usr %sys %wio %idle
Average 0 0 0 0 99
Average 1 0 0 0 100
Average 2 0 0 0 100
Average 3 98 1 1 0
I've seen this problem mentioned before in the forums
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-02-2009 08:53 AM
тАО03-02-2009 08:53 AM
Re: Oracle / CPU usages
You may find solutions by searching the previous threads in ITRC.
Checklist:
* OS patches - there may be new ones
* Oracle patches - this might be an oracle defect
* SGA settings
* Kernel settings.
There might be something different on this system causing the problem. Everything about this tells me to check for an application defect.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-02-2009 09:34 AM
тАО03-02-2009 09:34 AM
Re: Oracle / CPU usages
psrset
will show if you have more than the default PSET defined.
HTH
Duncan
I am an HPE Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-02-2009 09:48 AM
тАО03-02-2009 09:48 AM
Re: Oracle / CPU usages
>the exact kernel configuration that is not seeing these problems
Is it running the same applications?
Are you using any special scheduling software that would bind the application to just that CPU?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-02-2009 01:32 PM
тАО03-02-2009 01:32 PM
Re: Oracle / CPU usages
The really problem is probably that it is used 98% for SYSTEM time.
Figure out what is happening there!
Use TOP or UNIX95 PS -ef or whatever.
Maybe even system call tracing is needed.
This is NOT normal, and may well slow down everything. Swapping, caused by sever memory mis-configurations might explain this.
What is the memory/paging situation? vmstat?
>> I've seen this problem mentioned before in the forums
Ok, now pray tell, what were those topics? Did they help you? Did you follow up on suggestions and checks for that problem? what did you learn from that? What further clarification is needed?
Hope this helps some,
Best Regards,
Hein van den Heuvel ( at gmail dot com )
HvdH Performance Consulting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-02-2009 03:22 PM
тАО03-02-2009 03:22 PM
Re: Oracle / CPU usages
SELECT * FROM v$parameter
WHERE NAME='cpu_count'
will let you know how many CPU's it can use.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-02-2009 04:30 PM
тАО03-02-2009 04:30 PM
Re: Oracle / CPU usages
That last sentence should have read: I've seen this problem mentioned before in the forums, but haven't noticed any solutions.
Malcome, Cpu_count is 4.
Dennis. The processes will be different. This is a development box, the other is production. But the development kernel was copied from the production. Patches are the same.
Hein, Interesting. I will check that. I'm getting this from the Oracle DBA, so I assumed it's Oracle and not system processes, but I will definitely will check it out.
Duncan, no processor sets.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-02-2009 05:05 PM
тАО03-02-2009 05:05 PM
Re: Oracle / CPU usages
fwiw,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-02-2009 08:17 PM
тАО03-02-2009 08:17 PM
Re: Oracle / CPU usages
I read that as CPU 3, 98% user.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-03-2009 09:47 AM
тАО03-03-2009 09:47 AM
Re: Oracle / CPU usages
Darn 'spaceless' presentation in the ITRC forum.
Hein.