Re: Help ! Performance with Oracle 7.3

From: <gjlinker_at_geocities.com>
Date: 1998/01/22
Message-ID: <885489415.768540678@dejanews.com>#1/1

There is a way of determining whether the SQL is badly written or if there are missing indexes on the tables.

You can look at the execution plan Oracle uses to get all of your rows. Oracle will interpret the SQL and generate an execution plan to retrieve the data. The thing to avoid is that there are many full table scans performed.

To make the explain plan utility easy to use I wrote an Oracle Form with which you can actually play with it all. It takes your SQL and returns the execution plan. Additional help is available on all operations.

Have a look at http://members.aol.com/gjlinker I call the tool Explain.

Kind regards, Gerrit-Jan Linker

In article <69t8r1$88o$1_at_news.NetVision.net.il>,   "AF1" <tel_at_sddss.com> wrote:

>

> Hi,
> I am using a server NT 4 with Oracle 7.3. there is a table with 800 000
> Rows, I found the server very slow, but i don't know if it's a problem of
> tuning on oracle or if the server is not enought strong to run ORACLE. I
> give you the specification of Server:
> PC Intel Pentium 233 Mhz
> 64 Mo Ram
> Hard Disk SCSI 6 Go
> If you have any information on this case please help me !
> Thank you
> Richie

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Thu Jan 22 1998 - 00:00:00 CST