Re: Recommended datafile sizes.

Tim.Middleton_at_health.wa.gov.au wrote:
>
> Hi guys & gals,
>
> I am looking for some comments on the following scenario.
>
> I have a tablespace which is large (about 8Gb). When creating the
> datafiles for this tablespace, Is is better to have, say. 2 x 4Gb
> datafiles or should i have 16x500Mb datafiles.
>
> What are the advantages/disadvantages of each approach.
>
> Thanks very much.
>
> Tim Middleton
>
> PS. Please email me.
> PPS. Also where can i find the FAQ's for this newsgroup. Tar.
>
> Tim.Middleton_at_health.wa.gov.au.
> DMR Consulting Group Australia
> +619 222 4116
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

More importantly than anything else...get yourself a decent volume manager so that you don't have to worry about striping files within Oracle itself, or moving files around if disks fail etc etc

Cheers

-- 
Connor McDonald
Systems Administrator-Unix/Oracle
BHP Iron Ore
"You're not drunk if you can lie on the floor without holding on"
            - Dean Martin