RE: Relating OS processes to online users

If the queries are poorly written, then they generally stick around for a while and you can see them with onstat -g sql/ses. If these are DSS style queries then I'll direct you to an article in technotes Volume 10 Issue 1 - "Tuning Informix DSS Queries" - which walks through how to tune these. I'm told you can find it at idn. cheers j. -----Original Message----- From: nspaff@my-deja.com [mailto:nspaff@my-deja.com] Sent: Tuesday, November 07, 2000 6:14 PM To: informix-list@iiug.org Subject: Relating OS processes to online users Does anyone know how to take a process from the output of top and relate it to a particular oninit process, so that I can perform an onstat -g ses and get who is running what sql? We are havingperformance issues as a result of very poorly written queries. I would like to be able to identify the oninit sessionid using the most CPU via the OS pid from top. Anyone have any luck doing this? Or is there a better way that has been proven successful? We are running Informix 7.30.UC9 on Solaris 2.6. Any information would be appreciated. Thanks, Spaff Sent via Deja.com http://www.deja.com/ Before you buy.