Re: Creating datafiles for 500GB database

urockblue96_at_yahoo.com (Sandy N) wrote in message news:<49b1a424.0404111745.5f73779b_at_posting.google.com>...
> Hi,
>
> I have been entrusted the responsibility of creating physical
> structure of a datamart. Approximate size of the database would be
> 500GB. It will work on windows server. Till now I have been working
> mostly working with around 10 - 20 GB databases.
>
> Any indicators as to how much size I should go with the database files
> ? I was thinking of creating 50 10GB files. Does it sound feasible ?
> Any thoughts would be helpful.
>
> Regards
> Sandy

Sandy,

You might want to check out Oracle's Partitioning option. It is an additional fee on top of the Enterprise License. If you leverage Partitioning, you will be creating one or more datafiles for each tablespace mapped to each partition. This may make maintenance operations easier and allow for greater parallelization of tasks, such as loads and index create/rebuilds, use of parallel query option.

I would highly recommend reading the Oracle Data Warehousing guide. You can find all of Oracle's docs up on OTN: (free registration required)

http://otn.oracle.com/pls/db10g/portal.portal_demo3?selected=6

You'll also find articles up on OTN that are relevant.

hth.

Pd Received on Tue Apr 13 2004 - 15:42:01 CDT