peledc
asked on
Open process
Hi,
On linux 7.2 With Oracle 8.1.7
When I run the "top" command I can see that the load average is around 80 (Eighty) and the CPU is 80% idle.
While searching for the reasons for this I notice that there are around 243 idle appache process:
040 S oracle 1984 1982 0 69 0 - 3495 do_pol 2006 ? 00:00:00 /sdb1fs/app/oracle/product
I am a newbee on this subject. Can anyone help here?
Thanks
Alon Peled
On linux 7.2 With Oracle 8.1.7
When I run the "top" command I can see that the load average is around 80 (Eighty) and the CPU is 80% idle.
While searching for the reasons for this I notice that there are around 243 idle appache process:
040 S oracle 1984 1982 0 69 0 - 3495 do_pol 2006 ? 00:00:00 /sdb1fs/app/oracle/product
I am a newbee on this subject. Can anyone help here?
Thanks
Alon Peled
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
> Can I kill them?
No, they are immune to signals. They have to finish their current work.
> How should I address this?
Faster disks (raid arrays), better applications, smarter indexes in database, optimized queries(no temporary tables involved)
No, they are immune to signals. They have to finish their current work.
> How should I address this?
Faster disks (raid arrays), better applications, smarter indexes in database, optimized queries(no temporary tables involved)
ASKER
Is there a way to see what are they waiting for?
somthing like "truss" of Solaris?
somthing like "truss" of Solaris?
> Is there a way to see what are they waiting for?
Rather tought. The only thing that crosses my mind in this very moment: attach with debugger or strace.
But they surely wait for disk operation.
Check Your disks utilization with
iostat -x 5 # report every 5 seconds
Rather tought. The only thing that crosses my mind in this very moment: attach with debugger or strace.
But they surely wait for disk operation.
Check Your disks utilization with
iostat -x 5 # report every 5 seconds
ASKER
It seems the disks are idle:
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 2.00 0.00 0.60 0.00 20.80 34.67 0.00 0.00 0.00 0.00
sda1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
sda2 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
sda3 0.00 2.00 0.00 0.60 0.00 20.80 34.67 0.00 0.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 2.00 0.00 0.60 0.00 20.80 34.67 0.00 0.00 0.00 0.00
sda1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
sda2 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
sda3 0.00 2.00 0.00 0.60 0.00 20.80 34.67 0.00 0.00 0.00 0.00
Well, then maybe nfs?
And maybe it's worth to strace such processes?
And maybe it's worth to strace such processes?
ASKER
ps -efl | grep httpd|grep " D "
and got 80 process in D state.
How should I address this?
Can I kill them?