Re: Datafile sizes

constraints of using too many datafiles; 1. db_files need to be increased consistently. you can set it to a huge value if you like, but overhead in sga/pga is significant; 2. db_files means open file; you will need to enalrge system open file descriptor, as others says;
also pay attention to 1023 datafile limit per tbs; 3. with checkpoint, huge number of datafile *might* have impact. but it is kind of difficult to measure;

problem With resize:
you will need to enlarge your unix filesystem (not sure about vms) to resize your datafile, unless you preserve the disk storage at filesytem level;

is there any oppurtunity to archive the data? Consistently grow like that, is not a great idea for dba

On 5/3/07, Nigel Thomas <nigel_cl_thomas_at_yahoo.com> wrote:
>
> (sorry, forgot to copy to the list)
>
>
> >>Looking for comments & experiences regarding sizes of datafiles. We
> have a large (6+ TB) OLTP database....
>
> Dan
>
> you could do worse than google the oracle-l archives using search terms
> like 'datafiles', 'sizing', 'TB' etc; see for example:
>
> http://www.freelists.org/archives/oracle-l/09-2005/msg00093.html -
> Choosing data file size for a multi TB database?
> http://www.freelists.org/archives/oracle-l/11-2006/msg00626.html - Data
> file size - is bigger better?
>
> (I've picked messages at random - you'll need to search back and forth
> within these threads)
>
> Regards Nigel
>
>
>
>

-- 
Regards
Zhu Chao
www.cnoug.org

--
http://www.freelists.org/webpage/oracle-l