Re: Choosing between 8i Standard and Enterprise?

Answers embedded

Hth,

Sybrand Bakker, Oracle DBA

Malcolm Dunnett <dunnett_at_mala.bc.ca> wrote in message news:iRco+3rdYf30_at_malvm2.mala.bc.ca...
>
> I'm trying to understand the difference between Oracle 8i
> "Standard" and "Enterprise" editions. A lot of the differences
> are obvious ( such as bitmap indices ) but I have a couple of
> questions:
>
> 1.) A datasheet I've seen says "Online index build" is only
> available in the Enterprise edition. What does this
> feature mean? Does this affect ones ability to do
> CREATE INDEX and DROP INDEX commands while the database
> is being used?
>

Most likely the absence of ALTER INDEX REBUILD, which means a single step rebuild in situ

> 2.) Given identical databases and computer setups are there
> performance difference between Enterprise and Standard
> edition ( eg does Enterprise cache things any better or
> allow larger SGAs, etc ).
>

No

> 3.) If one is dealing with a database that has a thousand or
> so tables in total, with the largest tables having a couple
> of million rows ( total database size of 5-10GB ) and all
> access will be via SQLNet ( OCI and ODBC) is there
> any compelling reason to use Enterprise edition vs Standard?
>

the only two options that could come in handy are the partition option and the parallel query option.
With a total size of 5-10G I would want to have them. Received on Fri Feb 18 2000 - 11:54:08 CST