- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- "IMP" PROCESS BLOCK ON BY "IPC"?
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
тАО10-06-2008 10:41 PM
тАО10-06-2008 10:41 PM
"IMP" PROCESS BLOCK ON BY "IPC"?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-06-2008 11:21 PM
тАО10-06-2008 11:21 PM
Re: "IMP" PROCESS BLOCK ON BY "IPC"?
There doesn't appear to be any resource issues at all on this system (CPU/memory/IO). The only thing you don't see here is if there is pressure on some of the IPC resources (given your wait states perhaps you should check that)
Pressing 't' in glance will show you if you have contention there.
That said, more likely these processes are just waiting on a semaphore before continuuing work, which would point to something in Oracle. So unless any of your system tables are showing pressure I think this is one to look at from the Oracle perspective.
One other point - glance seems to be taking an awful lot of CPU time (although you have plenty to spare). I'd look at applying the latest patch bundle (Sep 08) to this system as well.
HTH
Duncan
I am an HPE Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-07-2008 12:33 AM
тАО10-07-2008 12:33 AM
Re: "IMP" PROCESS BLOCK ON BY "IPC"?
Each oracle process appears to be using 103 MB of ram.
It will not take long for you to run out of memory under these circumstances.
Check kernel params.
shmmax
Make sure it meets guidelines on your version of oracle.
Make sure it is adequate.
check shared memory processes. If any oracle shared memory areas are owned by root its game over, reboot time, oracle can not be run by root.
Also, your post.
No OS version
No Oracle Version
Lots of information that that could get you better help, missing in action.
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
тАО10-07-2008 04:07 AM
тАО10-07-2008 04:07 AM
Re: "IMP" PROCESS BLOCK ON BY "IPC"?
Also why do you have that many imp processes? Sometimes these imports will become serialized because of their own nature, (depending on what and where they import in the database), that is they have to run in sequence, when one of them completes a second one can start.
I think this is a database issue more than a kernel tuning issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-07-2008 04:35 AM
тАО10-07-2008 04:35 AM
Re: "IMP" PROCESS BLOCK ON BY "IPC"?
os version: 11.31,oracle: 10g;