Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Creating datafiles for 500GB database
Sandy N wrote:
> 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
Sounds reasonably irrelevant to me without considering the file sizes allowed by the operating system and the mechanism an hardware available for backup and recovery.
Of more concern would be things like PCTFREE and PCTUSED for your tables and indexes. In other words ... how much of that 500GB are you using/wasting?
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Sun Apr 11 2004 - 23:26:11 CDT
![]() |
![]() |