Re: SQL statistics

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1996/12/04
Message-ID: <32A679D4.DC5@qrcsun.qrc.org>#1/1

Zernan Martinez wrote:
>
> Does anybody know how to display statistics on a SQL request?
> I would like to know how Oracle processed my query any hopefully be
> able to optimize my request.

You can use EXPLAIN PLAN to check the execution plan and SQL_TRACE to trace the statistics on SQL statement execution.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

Received on Wed Dec 04 1996 - 00:00:00 CST