Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Choosing between 8i Standard and Enterprise?

Re: Choosing between 8i Standard and Enterprise?

From: Van Messner <vmessner_at_bestweb.net>
Date: Sun, 20 Feb 2000 01:04:41 GMT
Message-ID: <J4Hr4.5768$JQ.335080@monger.newsread.com>


To answer question three (only), that database should run just fine on the standard edition.

Van

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?
>
> 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 ).
>
> 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?
>
Received on Sat Feb 19 2000 - 19:04:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US