Re: tablespace partition performance trustworthy ?

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 02 Oct 2002 15:18:59 GMT
Message-ID: <3D9B0E4C.9E9B75D3@exesolutions.com>

Ginger Mall wrote:

> My scenario is to build up a database system with 5GB of data increase
> daily. I know that the data could be allocated by table partition. I am
> planning to use 5 to 10 physical disk on SunSparc machine for
> implementation. Anyone have working experience on it ? Is it stable and
> provide good peformance ? Can Oracle really processes and retrieves the
> data in parallel ?
>
> Thanks !!

It is excellent.

But exactly what do you mean by 5 to 10 physical disks? There are either 5 or 10 or some number inbetween. And either way ... unless you are striping that is too few disks. And even with striping too few disks. I would suggest you get a UNIX sysadmin to look at your storage and retrieval requirements.

Simple math looks something like this:

(5GB data + index entries) * 260 business days per year = ... a lot more space than you have available

Daniel Morgan Received on Wed Oct 02 2002 - 10:18:59 CDT