Re: Sv: How to speed up my SQL commands?
From: <no.spam_at_columbus.rr.com>
Date: Fri, 28 Jan 2000 17:02:43 GMT
Message-ID: <TYjk4.17371$%%6.217508_at_typhoon.columbus.rr.com>
:> I have performance problems with my SQL statments in my Oracle 8.1.5 db.
:> Does any body knows where can I find the ORACLE SQL ANALYSE
:> tool (or similar) to help me improve my SQL statments?
:>
:> Thank you!
:> Manuel Dias
:>
:>
:>
Date: Fri, 28 Jan 2000 17:02:43 GMT
Message-ID: <TYjk4.17371$%%6.217508_at_typhoon.columbus.rr.com>
This isn't too bad of a tool to use. Has helped me, but I find tkprof to be the best tool to use for situations like this. It's gets into more detail just explain plan. The cost values explain plan shows are misleading.
In comp.databases.oracle.tools Freddy Kristiansen <fk_at_dsinet.dk> wrote: : Check out www.toadsoft.com
: Manuel Dias <manueld_at_burotica.pt> skrev i en : nyhedsmeddelelse:86rshr$euh$1_at_duke.telepac.pt...
:> I have performance problems with my SQL statments in my Oracle 8.1.5 db.
:> Does any body knows where can I find the ORACLE SQL ANALYSE
:> tool (or similar) to help me improve my SQL statments?
:>
:> Thank you!
:> Manuel Dias
:>
:>
:>
-- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Ivan Samuelson * Staff Support Coordinator and * isamuels_at_columbus.rr.com Information Systems Consultant * Metro Information Services * http://home.columbus.rr.com/isamuels http://www.MetroIS.com * -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Received on Fri Jan 28 2000 - 18:02:43 CET