- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- My Oracle "imp" processes sleep quite frequently
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
10-27-2006 06:41 AM
10-27-2006 06:41 AM
My Oracle "imp" processes sleep quite frequently
I understand processes go to sleep and are swapped out from the run-queue when they are waiting for resources. I also understand that no CPU usage is consumed when out of the run-queue and sleeping.
But, what is the problem?
Sar -Mu 5 5 shows:
14:35:54 cpu %usr %sys %wio %idle
Average 0 34 11 15 40
Average 1 31 12 11 45
Average 2 33 12 9 46
Average 3 32 12 9 47
Average 4 34 12 10 45
Average 5 33 13 10 44
Average 6 36 11 9 45
Average 7 39 12 6 43
Average system 34 12 10 44
sar -d 5 5 shows:
14:37:28 device %busy avque r+w/s blks/s avwait avserv
Average c0t6d0 0.64 0.50 1 18 0.00 7.05
Average c20t0d0 77.11 0.55 721 22052 0.01 1.51
Obviously, c20t0d0 (SAN disk) is showing the maximum activity. But the SAN disk has been created as a LUN from a disk pool / group of multiple disks physically on the EVA5000 disk array. I don't understand. Please help!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-22-2007 03:04 AM
05-22-2007 03:04 AM
Re: My Oracle "imp" processes sleep quite frequently
No CPU cycles are burnt when waiting for I/O to complete. Since you are importing large tables, most of the time your process waits (in sleep mode) for your san to finish reading or writing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-22-2007 05:56 AM
05-22-2007 05:56 AM
Re: My Oracle "imp" processes sleep quite frequently
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-22-2007 12:27 PM
05-22-2007 12:27 PM
Re: My Oracle "imp" processes sleep quite frequently
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2007 12:39 AM
05-23-2007 12:39 AM
Re: My Oracle "imp" processes sleep quite frequently
-- Ravi.