Re: Standard Edition (One) and terabyte data

From: Niall Litchfield <Niall.litchfield_at_dial.pipex.com>
Date: Sun, 02 Oct 2005 17:22:43 +0100
Message-ID: <43400831$0$3575$cc9e4d1f@news.dial.pipex.com>

Arto Viitanen wrote:
> We are obtaining a dedicated database server for a repository
> that will contain terabytes of data (about 2-3 at start). Since the
> server will be a dual cpu computer, Oracle Standard Edition One could be
> suitable software. But, I just found (on some small print on the data
> sheet) that it "for databases up to around 500 GB of Data".
>
> What does this mean? Can I not set tablespace larger than 500 GB,
> or is this only some kind of recommendation?

It is a recommendation. The limit is 2 cpus for SE One, and I think there is a memory limit of 4gb as well. The limits are listed in the guide to the product editions.

You won't however be able to use partitioning or parallelism (the latter saving you from yourself on SEOne) or things like online rebuild in SE One. These limitation will likely hurt you badly in a terabyte environment. Note that you don't get partitioning for free with any edition of Oracle (unless you negotiate it).

Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com Received on Sun Oct 02 2005 - 11:22:43 CDT