Re: tablespace partition performance trustworthy ?

thanks !!

Actually I have not determine the number of disk and the data will only be kept online no more than 1 month. As such there will only be 100 ~ 200 GB in total. One more thing is I have to do the task of "UNIX sysadmin". It means I need to help myself. poor ~_~

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3D9B0E4C.9E9B75D3_at_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 Thu Oct 03 2002 - 02:14:53 CDT