Re: query performance tools

June C. Hunt said: > "Obnoxio The Clown" <obnoxio@serendipita.com> wrote: >> >> 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. I'm sorry to pick nits with someone who has just been so gracious, but the problem with onstat -g sql is that it doesn't on some plaforms and some releases show the last parsed SQL. It will still show the currently active SQL. (And with values to plug in the placeholders! Hurrah!) > [P.S. Thanks for the giggle. It has been rather, um, dry here without > you.] I don't know what I could have contributed that "Noons" hasn't, apart from charm, grace, style, wit, good looks ... ah. (The lovely thing about the internet is, you can grab a similar name from a different ISP, swipe someone's .sig from thousands of posts, freely available, and everyone will believe you're the same person. :o) -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco sending to informix-list

"Obnoxio The Clown" <obnoxio@serendipita.com> wrote: > June C. Hunt said: >>You must have missed the "onstat -g sql in 9.4" thread while you were >>catching up [...] > > I'm sorry to pick nits with someone who has just been so gracious, but the > problem with onstat -g sql is that it doesn't on some plaforms and some > releases show the last parsed SQL. It will still show the currently active > SQL. (And with values to plug in the placeholders! Hurrah!) Ah, you *are* paying attention! :-) Thanks for the clarification. > I don't know what I could have contributed that "Noons" hasn't, apart from > charm, grace, style, wit, good looks ... ah. You forgot to throw in modesty, perhaps? :-) -- June Hunt