Need a real stats tool, tkprof is hopeless. Help !
Date: 1995/05/10
Message-ID: <3orsrb$ne_at_voyager.cris.com>#1/1
I've been thrown to the wolves and given only tkprof to tune a truly god-awful query on some large (1.5 million rec) tables. The explain plan option of Tkprof quits working somewhere after 90000 records -- and I have no idea of why. Change the select parameters (date), rearrange the query, and it sometimes works. But that's not exactly useful, as I'm rearranging the query to get performance !
I'm looking for info on any query tuning tool (oracle 7.0.14 and up) that has worked for anybody out there - I think my client will buy one if I can get a referral. What I need are stats on cpu & IO, as well as how many hits we got on each piece of the query (much like TKProf explain would give, if it worked :( ). BTW, we run on VMS and Unix both, I'll take anything that runs on either (can you tell I'm getting desperate ?).
Anybody got any ideas ?? Answer here or email me at ayana_at_cris.com. TIA Ayana Craven
--
ayana_at_cris.com Ayana CravenIsn't there *any* good real-time database out there ?? Just *one*, that actually works, and is robust ??
--
ayana_at_cris.com Ayana CravenIsn't there *any* good real-time database out there ?? Just *one*, that actually works, and is robust ?? Received on Wed May 10 1995 - 00:00:00 CEST