- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: DB gets 100% of cpu time
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
тАО07-22-2007 08:08 PM
тАО07-22-2007 08:08 PM
I've a terrible problem. We run a single instance db on an rp4440 with HP/UX 11.11 64-Bit.
If we start this instance it will consume all the cpu time.
We've an RAC db installed on this machine but it's the same problem with the RAC instance started or not.
Does anyone has an idea where to start analyze this "feature"???
regards
Christian
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-22-2007 08:18 PM
тАО07-22-2007 08:18 PM
Re: DB gets 100% of cpu time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-22-2007 11:38 PM
тАО07-22-2007 11:38 PM
SolutionHow much time do this situation persist?
There could be scheduled jobs that starts to run as soon as the database is up.
(to check: select * from dba_jobs_running;)
Does the alert.lgo show any error messages?
revert
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-23-2007 02:31 AM
тАО07-23-2007 02:31 AM
Re: DB gets 100% of cpu time
yes we've tried the to set job_queue_processes to 0 and it doesnt change everything.
The issue occurs all the time and the alert.log shows nothing?!?!?!?!?
Thats my problem I dont know where to look ...
regards
Christian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-23-2007 03:18 AM
тАО07-23-2007 03:18 AM
Re: DB gets 100% of cpu time
Does anything odd show up in the top SQL report?
Does it happen if you don't open the DB upon startup?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-23-2007 04:01 AM
тАО07-23-2007 04:01 AM
Re: DB gets 100% of cpu time
How long does it take to max out your cpu util?
I would suggest that you monitor the cpu and run a cpu report over the time frame that begins when you start the instance and track the cpu util.
If you haven't already looked, I would check with Oracle about this behavior and see if there isnt a patch or a configuration setting that you are missing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-23-2007 04:07 AM
тАО07-23-2007 04:07 AM
Re: DB gets 100% of cpu time
Has there been any changes prior to this behaviour? Changes at the SGA level?
Can you post a sample output from TOP? Did you try to relate the top processes with database sessions at the instance level?
revert
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-23-2007 03:42 PM
тАО07-23-2007 03:42 PM
Re: DB gets 100% of cpu time
What are the names of the processes that are using the cpu cycles ? Glance is the best tool for finding this out. If you don't have Glance, you can use top or repeated ps commands - looking at changes in cpu consumption.
Is any Oracle work getting done when this occurs ?
Ken Johnson
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-23-2007 06:27 PM
тАО07-23-2007 06:27 PM
Re: DB gets 100% of cpu time
there was a HP/UX patch installed on the one machine and after that this error occurs. Right now the unix-admins have restored the hole machine to an prior patch backup and everything works fine. But I cannot analyze this "feature" anymore.
Thanks for your help!
regards
Christian