Re: Performance on HP unix

Ahmad Ramzi Salleh <ramzi@telekom.com.my> wrote: > > Hi, > I'm running New Era 2.20 for end-user and using Informix 7.13 on HP-UX > 10.01. > Can anyone tell me how to identify which session take up CPU resources > because > sometimes when ever I issue top command on unix, %CPU goes as high as > 90% > for oninit command and CPU idle percentange drops to 20% and it will > slow down > the process. > Currently I'm using onstat -g ses command but it doesn't help much. > All the end-users are connecting to database using single username. > Thank you in advanced. > You can catch active thread with 'onstat -g act -r 2'. Then you can use value of 'rstcb' column of previous output to catch session: 'onstat -u | grep value_of_rstcb Then you can get sql causing high CPU utilization, though the source of problem can be not query itself but anything in your configuration, database design, etc. 'onstat -g ses' will show you hostname of particular user. hth Vardan -- Vardan Aroustamian vaar@geocities.com