Our SAN has been setup as RAID5, so the use of single large datafiles is probably the method I will go with, using the added option of resizing once I read up on it some more :)
Darren -----Original Message----- Sent: Wednesday, September 25, 2002 8:13 PM To: Multiple recipients of list ORACLE-L It's late at night maybe that's why I do not understand your answer but I do not see the link between LMT and the number/size of datafiles. One reason of multiple datafiles id to spread IO but since nowadays a majority of sites goes on huge disk box using raid 5 (that's what we have, the unix guys are the IT master here) multiple files is less meaningful. What I liked is a file politics where you restrained the number of file size. Here we have from 15M up to 8.5G file size with all the possibility in between. I'm trying to standardize all that. Another factor to consider is backup and recovery. Restoring a 10G file will take more time than a 2G file. In your case, if file placement is not possible than go for a 800M file and use a second one for the future growth. -- DENNIS WILLIAMS <[EMAIL PROTECTED]> a écrit : > Darren - My advice would be to read up on Locally > Managed Tablespaces (LMT) > and uniform extents. This is a new feature that will > ease your management > work. > > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -----Original Message----- > Sent: Wednesday, September 25, 2002 6:43 PM > To: Multiple recipients of list ORACLE-L > > > I am in the process of upgrading our databases from > 8.0.5 to 8.1.7, > possibly 9i depending on application > certifications. > > I currently have a tablespace that is made up of 4 - > 200mb datafiles, my > first thought would be to > create a 800mb datafile and move all the data into > it, > > The growth of this tablespace is maybe 100 to 150Mb > a year, and from > what I understand all datafiles should > be the same size. So at that point when I need > another datafile, I will > have to create another 800Mb datafile. > > Would that be a good practise, or should I stay with > multiple > 200/300/400/500 etc datafiles ? > > Thanks > > Darren > ------------------------------------------------------------------------ > -------------------------------------------------- > Darren Browett P.Eng This > message was transmitted > Data Administrator using > 100% recycled electrons > Information and Communication Technology > City of Coquitlam > P:(604)927 - 3614 > E:[EMAIL PROTECTED] > ------------------------------------------------------------------------ > --------------------------------------------------- > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Browett, Darren > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > ===== Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___________________________________________________________ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
