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?
typo: 800mb is 800gb. it would be tuf to fit a 10gb datafile in a 800mb db. >>> [EMAIL PROTECTED] 06/01/01 04:03PM >>> 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). -- 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).
Re: data files - How big?
We use up to 2GB datafiles for our production SAP system with no problems, and, so far, have around 470 datafiles. What you need to remember is that your datafile size becomes your unit of recovery. For example, if you lost a particular datafile (corruption, deletion, whatever), and had to restore it from a tape backup, obviously the smaller the file, the faster the recovery. For our large SAP system, we have balanced that versus the practicality of not having to add an additional datafile every 15 minutes. Also, as Jared mentioned, certain software solutions can't work with files over 2GB. Our EDM tape server cannot backup files larger than 2GB. Jim -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) > > 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: Jim Hawkins 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).
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?
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?
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).