I am running a data export process. Normally it takes about 2 hours but now more 25 hours past, it is still running. The result of "top" shows 154 processes of 179 are sleeping. How to tune hp-ux?
Well if you find almost all processes (oracle)are in sleep state since long time,then u can take the decisions to kill the same with proper approvals,
But after looking at vmstat output,cpu is idle and there is hardly utilisation.
2]Memory :
It is most important parameter to check if you are getting very slow response.
in vmstat output, i am looking lots of page out, it means u are going short of memory,and swap utilisation is more.check, #swapinfo -tam,
Action :
If you see more swap utilisation,then,
run below command,
#ipcs -mob ex.
#ipcs -mob IPC status from /dev/kmem as of Tue Aug 25 13:34:26 2009 T ID KEY MODE OWNER GROUP NATTCH SEGSZ Shared Memory: m 0 0x411c0189 --rw-rw-rw- root root 0 348 m 1 0x4e0c0002 --rw-rw-rw- root root 2 61760 m 2 0x41201f8a --rw-rw-rw- root root 1 8192 m 3 0x00a5c581 --rw------- sfmdb users 4 10469376 m 32772 0x06347849 --rw-rw-rw- root root 2 65544 m 65541 0x0c6629c9 --rw-r----- root root 2 17868736 m 163846 0x491823a2 --rw-r--r-- root root 0 22908
If you see 7th Column (NATTCH )any process is having 0 value, that means thease processes are completed and still they didn't release the memory segment
You can release thorough
#ipcrm -m (Be careful while running this command)
3]Disk utlisation :
#Using iostat command,check any perticular disk is showing any abnormal behavior,
4]Network
On critical server,usually export,back thease activities should do when there will be less load on the server.these can be depend on LAN speed.
Re: slow performance, run a process takes up 25 hours
The c4t0d1 disk is rather busy. That alone however does not justify the 25 hours. Maybe this disk was just as busy when the export job took only 2 hours. You have to check a few more things.
Have you added any data recently to this database environment? Are there other processes running that conflict in i/o with the export job? Are there other processes running that cause locking in the data that would suspend the export job completely until the locking is cleared? Check the syslog if there are any issues with the c4t0d1 disk. Maybe read or write errors and retries. Check around in the database for anything else that niormally does not run during the export process.
Re: slow performance, run a process takes up 25 hours
ninode and vx_ninode create roll-over tables in memory. Letting the parm algorhythm do it creates tooooo big a table and wastes memory. Ditto for vx_ninode.
Drop your ninode value to 2048. Requires a reboot. If your vx_ninode is set to 0 then change it to maybe anywhere from 20,000 to 100,000.
I don't see how much memory you have on this box, just swap on lvol2. So I would at least add 8Gb more of swapspace and use SAM to set it up immediately. You can still do that since your only at 11.23.
It may be an old process didn't clean out of memory correctly, so from top you may not see it. You can do a reboot and see if it cleans up anything left over your not able to identify. You can use that reboot as an opportunity to make these couple of simple parm changes (if you like).
Re: slow performance, run a process takes up 25 hours
Have you added any data recently to this database environment? --> no. Are there other processes running that conflict in i/o with the export job? --> no. Are there other processes running that cause locking in the data that would suspend the export job completely until the locking is cleared? --> no locking. export data is not like modify, no exclusive lock is required. Check the syslog if there are any issues with the c4t0d1 disk. Maybe read or write errors and retries. --> nothing about "c4t0d1" nor sys error. Check around in the database for anything else that niormally does not run during the export process. --> checked database level, nothing changed recently and it's working normal. export process normally take 2 hours, but it is too long this time (and still hanging).
Re: slow performance, run a process takes up 25 hours
Is there an output file that these two jobs write to? If so does it grow in size? If it does not change in size, it would mean that the two jobs are hung somehow. You might consider killing them and restarting them.
Re: slow performance, run a process takes up 25 hours
yes, i am monitoring the output data. the file size keep growing. That meaning the process is runing but it is too slow. anything elso to check at the OS level?
Re: slow performance, run a process takes up 25 hours
Unfortunately, there isn't much you can do with the OS because you did not de-tune the OS. In other words, it used to run in a couple of hours and without (I assume) changes to the OS, the process is running at a much slower rate.
When I see a massive slowdown like this, I immediately check for NFS. If you have any NFS activities, shut them down completely (no automounter, nothing related to network filesystems. I would expect bdf and logins are running slowly too.
