Re: Parallel Execution: Oracle8 Ent. Ed. vs. Server

Sybrand,

Thanks for the follow up. I believe that I qualified my statement by saying that for the purposes of this particular application, that was the only difference I couldn't reconcile. I am well aware of the significant differences in the offerings but was trying to determine whether an application, if not coded specifically to take advantage of parallel execution features in Oracle Ent. Ed. (which most aren't), would benefit from the nearly seven times increase in cost of the Enterprise vs. Workgroup editions.

Thanks again,
SR

On Mon, 23 Oct 2000 18:05:44 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>Visit http://www.oracle.com/availability and you will see your assertion the
>*only* difference is Parallel Query is utterly untrue. Enterprise comes with
>objects, function based indexes, a facility to replace literals by bind
>variables and so and so on and so on.
>With respect to parallel query, you can enforce parallelism on several
>levels
>instance wide
>per table (by modifying your tables attributes in the dictionary)
>per statement by using hints.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
>
>
>
><speedrazer_at_usa.net> wrote in message
>news:jlk8vss21isvn0ohs62oerktesb69dr1be_at_4ax.com...
>> Hello, all! I'm trying to decide whether or not to license the Oracle
>> 8 Enterprise Edition or Workgroup Server and from what I can tell, the
>> only real difference, for the sake of the application that would be
>> running on it, is the issue of Parallel Execution of SQL. My question
>> about this is whether Oracle parallelizes execution by default if the
>> Enterprise Edition is installed or whether the SQL needs to be written
>> with the proper hints or explicit commands.
>>
>> Many thanks! -SR
>
  Received on Mon Oct 23 2000 - 17:34:37 CDT