Re: query performance tools

"June C. Hunt" <june_c_hunt@hotmail.com> wrote in message news:<2i9ei9FkgvisU1@uni-berlin.de>... > "Obnoxio The Clown" <obnoxio@serendipita.com> wrote: > > > > tomL said: > > > hello all, > > > > > > we are in dire need of optimizing sql for our system. Are there > > > techniques or (ESPECIALLY!) tools we can use that will monitor sql > > > sent and report on the worst performing sql utilized in our system? > > > > > > We are on informix 9.40 FC3 on hp-UX 11i > > > > I can be hired for a reasonable sum. I've been told quite often that I'm a > > tool. > > > > Oh, sorry. "Fool". Apparently I'm a fool. Is that the same thing? > > Not exactly. But if I had to pick one... :-) > > > Have you considered onstat -g sql? > > You must have missed the "onstat -g sql in 9.4" thread while you were > catching up, or maybe you haven't gotten to it yet. There is a bit of a > problem there that should be corrected with 9.40.UC5, with a fix available > for UC4. Haven't seen any information on the 9.40.FCx set. I do know that > 9.40.FC2 has the problem... on AIX 5.2.0.0 - in case that makes a > difference. (It might - Paul Watson said it was fine with 9.40.UC3 on > Solaris 7.) In any case, that command on 9.40.FC3, hp-UX 11i may not give > the information that you were suggesting. Sorry, the code fix for the bug that was previously identified here will be included in 9.40.xC5 (wher x = "U" or "F" or whatever the Windows letter is) If a fix is available in UC4W2 or UC4W3 then if a FC4W2 or FC4W3 exists for your 64 bit platform the fix will be in that too > > [P.S. Thanks for the giggle. It has been rather, um, dry here without > you.]