Re: How to speed up my SQL commands?

From: <no.spam_at_columbus.rr.com>
Date: Fri, 28 Jan 2000 17:01:30 GMT
Message-ID: <KXjk4.17358$%%6.217508@typhoon.columbus.rr.com>

You're best bet is to use TKPROF which is better than just a explain plan. It will show how many rows you are returning for each step.

Under SQL*PLUS, just do an ALTER SESSION SET SQL_TRACE=TRUE;

Run your select, exit and go to where the trace file is at and then do:

tkprof <trace filename> <output filename> explain=userid/password

In comp.databases.oracle.tools Manuel Dias <manueld_at_burotica.pt> wrote:
: 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 - 11:01:30 CST