Path: utzoo!utgpu!news-server.csri.toronto.edu!clyde.concordia.ca!uunet!decwrl!apple!hercules!fernwood!oracle!news
From: kbittner@oracle.uucp (Kurt Bittner)
Newsgroups: comp.databases
Subject: Re: Oracle vs. Ingres (UNIX)
Message-ID: <1990Aug27.025016.25940@oracle.com>
Date: 27 Aug 90 02:50:16 GMT
References: <1927@unsvax.NEVADA.EDU> <39@unigold.UUCP>
Reply-To: kbittner@oracle.UUCP (Kurt Bittner)
Organization: Oracle Corporation, Belmont, CA
Lines: 41

In article <39@unigold.UUCP> lance@unigold.UUCP (Lance Ellinghouse) writes:
>In article <1927@unsvax.NEVADA.EDU>, davidg@uns-helios.nevada.edu (DAVID GONZALES) writes:
>> 
>> 
>> We are currently planning on purchasing either Oracle or Ingres to run
>> on a Sun SparcStation. Anyone care to comment on one or both of these products?
>
>Well, 
>  I have used both on SCO Xenix(Oracle) and SCO UNIX(Ingres).
>Oracle is a good product, but it has some major flaws in my eyes:
>	1) Very Slow
>	2) Very few DBA utilities
>	3) SQL*Forms is not very flexable and has bugs
>
>Ingres is a good product also, and I prefer it over Oracle now that
>I am using it. Some of its features are:
>	1) Much faster than Oracle
>	2) Ability to monitor HOW the Query Execution Plan is
>		put together (thus able to tweek the search routines
>		a little more than Oracle)
>	3) Many DBA utilities and much better thought out
>	4) Their Forms routines are GREAT! Both under ESQL and
>		as standalone Forms used by their routines.
>

I am curious: is your Oracle experience with v5 or v6?  My experience with
Oracle v6 under Xenix has been very good - much faster than v5.  Also the
DBA utility, SQL*DBA, provides a HUGE amount of tuning information.  Also,
there is support for an DB2-compatible EXPLAIN facility (should address your
point #2 under Ingres).  As for Ingres point #4, SQL*Forms v3 (beta on Xenix
and SCO UNIX) should cause you to reconsider Oracle point #3.

Sorry for the plug, but your evaluation comments, however valid, are based on
a two-year old, obsolete product.  My comments are in the interest of comparing
apples to apples.

Kurt Bittner
Staff Tech Specialist
Oracle Corp.

My opinions are solely my own (who else would want them?).