RE: data files - How big?
I personally am not a fan of auto extend. I like to have a procedure when adding new data files. I tend to keep data files smaller against popular opinion, there is no performance loss with many different data files. Also there is less likely of having OS locks when data files are more and smaller. Also, it is much easier to manage them if they need to be moved around if they are only 100 or 500Mb rather than 10Gb or 100Gb. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, June 01, 2001 10:40 AM To: Multiple recipients of list ORACLE-L I am setting up a new linux server (redhat 6.2 oracle 8i 8.1.7) with a 1Ghz Processor and 512Mb RAM. How large should individual data files in a tablespace be allowed to grow? I can't find any advice on this in my oracle manuals/books. Is there a data file size that starts to hurt oracle. I've got one tablespace that will have 1-1.5 Gb of data. Should I allow a datafile to grow to that size, or would oracle like it better if I split it into 3 500Mb datafiles? Likewise, how should I handle the SYSTEM tablespace? Should I leave it as 1 large datafile or should it be broken into smaller ones? I would also like to know what good oracle email lists are available to ask dba related questions other than this one. Thanks, Barry Stubbs Windham School District -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Stubbs INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: data files - How big?
There was a 2gb limit on exp/imp previous to 8.0.5.1. Oracle fixed them with that patch. Rodd Holman Original Message dated 6/1/01, 11:53:54 AM Author: Jared Still [EMAIL PROTECTED] Re: Re: data files - How big?: A general rule of thumb for many people is to not allow datafiles larger than 2Gb. You will find many variations on that theme ( some don't like files larger than 512Mb ) but the 2Gb limit is due to possible limitations in other software. You may run into trouble with backup software that doesn't know how to deal with files that large. I've heard reports that some of Oracle's utilities do not always work correctly with large files, though I can't recall any details on that. My system has a 2Gb datafile on linux, and hasn't caused my any problems, but this is not a production system and isn't stressed. ( or backed up ) HTH Jared On Friday 01 June 2001 07:40, Barry Stubbs wrote: I am setting up a new linux server (redhat 6.2 oracle 8i 8.1.7) with a 1Ghz Processor and 512Mb RAM. How large should individual data files in a tablespace be allowed to grow? I can't find any advice on this in my oracle manuals/books. Is there a data file size that starts to hurt oracle. I've got one tablespace that will have 1-1.5 Gb of data. Should I allow a datafile to grow to that size, or would oracle like it better if I split it into 3 500Mb datafiles? Likewise, how should I handle the SYSTEM tablespace? Should I leave it as 1 large datafile or should it be broken into smaller ones? I would also like to know what good oracle email lists are available to ask dba related questions other than this one. Thanks, Barry Stubbs Windham School District -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: data files - How big?
Barry, RedHat has a limit of 8GIG partitions on the disk. I have 2- 40 GIG drives with 5 partitions each. One is used for indexes anf the other one is for data. The original drive is for the exe's and swap, and Oracle. To make things simpler to manage i spread my data and indexes (partitioned by year) acrocc the different partitions. All data and index datafiles are LMT and the largest I have so far is 2 GIG made up of uniform extents of 20 MEG each. Works real fast on a table of approx 6 GIG in total size. ROR mª¿ªm [EMAIL PROTECTED] 06/01/01 10:40AM I am setting up a new linux server (redhat 6.2 oracle 8i 8.1.7) with a 1Ghz Processor and 512Mb RAM. How large should individual data files in a tablespace be allowed to grow? I can't find any advice on this in my oracle manuals/books. Is there a data file size that starts to hurt oracle. I've got one tablespace that will have 1-1.5 Gb of data. Should I allow a datafile to grow to that size, or would oracle like it better if I split it into 3 500Mb datafiles? Likewise, how should I handle the SYSTEM tablespace? Should I leave it as 1 large datafile or should it be broken into smaller ones? I would also like to know what good oracle email lists are available to ask dba related questions other than this one. Thanks, Barry Stubbs Windham School District -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Stubbs INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: data files - How big?
IMHO, it depends on the database sizing requirements. I have a 1gb db and the datafiles range in size from 100mb to 2gb. On the other hand, I have a 800mb db and the datafiles range in size from 100mb to 10gb. The larger datafiles are used for our images tablespace (~500gb). 50 x 10gb datafiles is reasonable for a 500gb tablespace. I couldn't imagine 250 x 2gb datafiles. I like to keep my tablespaces at least 30% free. It helps me sleep at night :). As for software/hardware not supporting 2gb filesize, time to upgrade or replace. Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).