Re: query performance tools

"June C. Hunt" wrote: > > "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. > > [P.S. Thanks for the giggle. It has been rather, um, dry here without > you.] > -- > June Hunt small hint for those folks missing good old onstat -g sql Give onstat -g stm a try! dic_k -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe

"Richard Kofler" <richard.kofler@chello.at> wrote in message news:40C211D6.35DCC9D7@chello.at... > Give onstat -g stm a try! Huh?

"Neil Truby" <neil.truby@ardenta.com> wrote in message news:2ieuk1Fm0v7lU1@uni-berlin.de... > "Richard Kofler" <richard.kofler@chello.at> wrote in message > news:40C211D6.35DCC9D7@chello.at... > > > Give onstat -g stm a try! > > Huh? Oh, it's a 9.40 thiing ...