RE: Auto Extend
Hi John, I still haven't learned not to make sweeping statements on mailing lists = ) I expected someone to raise SMON or checkpoint overheads so I added "necessarily" very deliberately. Agreed, I'd tend to keep the number of files down to a reasonable number but I've run a database with 3,500 datafiles and it didn't choke on log switches at all. As you say, appropriately sized redo logs can mitigate the effects to some extent. Regards, Mike Hately, Oracle DBA John Kanagaraj <[EMAIL PROTECTED]> >Neither large files nor small files are evil. As with all >things, fit the >solution to the problem. >Small files can leave you with lots of separate datafiles which isn't >necessarily a drag on performance but can be an administrative >chore and can >cause more wasted space due to that pesky 'end-of-datafile' >free extent. Mike, I will have to disagree with you about small files not necessarily being a drag on performance. Given a specific size of a database, it would be better to go in for larger files (avoiding the >2Gb pitfall if possible) since each datafile adds its own component to the flurry of I/O activity that takes place during log switch, i.e. when all datafile headers need to be updated. In simpler terms, (Large number of) Small datafiles + small redo logs + high DML activity = disaster during (the frequent) log switches... >People who want to >set up databases larger than a terabyte will inevitably have a >budget to invest >in new kit and buy-in to up to date OS and software levels. >Not everyone has >that luxury and a lot of legacy kit doesn't like 2GB+ files. > >That's only my opinion but really, why play around with any >area that is >demonstrably strewn with bugs unless you need to? Fully agreed! John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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: 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: Auto Extend
Good point John for large databases. We were using 20 gig files in a Lawson system on AIX. Great for DW. Jared On Friday 01 June 2001 15:22, John Kanagaraj wrote: > >Neither large files nor small files are evil. As with all > >things, fit the > >solution to the problem. > >Small files can leave you with lots of separate datafiles which isn't > >necessarily a drag on performance but can be an administrative > >chore and can > >cause more wasted space due to that pesky 'end-of-datafile' > >free extent. > > Mike, I will have to disagree with you about small files not necessarily > being a drag on performance. Given a specific size of a database, it would > be better to go in for larger files (avoiding the >2Gb pitfall if possible) > since each datafile adds its own component to the flurry of I/O activity > that takes place during log switch, i.e. when all datafile headers need to > be updated. > > In simpler terms, (Large number of) Small datafiles + small redo logs + > high DML activity = disaster during (the frequent) log switches... > > >People who want to > >set up databases larger than a terabyte will inevitably have a > >budget to invest > >in new kit and buy-in to up to date OS and software levels. > >Not everyone has > >that luxury and a lot of legacy kit doesn't like 2GB+ files. > > > >That's only my opinion but really, why play around with any > >area that is > >demonstrably strewn with bugs unless you need to? > > Fully agreed! > > John Kanagaraj -- 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).
RE: Auto Extend
>Neither large files nor small files are evil. As with all >things, fit the >solution to the problem. >Small files can leave you with lots of separate datafiles which isn't >necessarily a drag on performance but can be an administrative >chore and can >cause more wasted space due to that pesky 'end-of-datafile' >free extent. Mike, I will have to disagree with you about small files not necessarily being a drag on performance. Given a specific size of a database, it would be better to go in for larger files (avoiding the >2Gb pitfall if possible) since each datafile adds its own component to the flurry of I/O activity that takes place during log switch, i.e. when all datafile headers need to be updated. In simpler terms, (Large number of) Small datafiles + small redo logs + high DML activity = disaster during (the frequent) log switches... >People who want to >set up databases larger than a terabyte will inevitably have a >budget to invest >in new kit and buy-in to up to date OS and software levels. >Not everyone has >that luxury and a lot of legacy kit doesn't like 2GB+ files. > >That's only my opinion but really, why play around with any >area that is >demonstrably strewn with bugs unless you need to? Fully agreed! John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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: Auto Extend
Hi, Neither large files nor small files are evil. As with all things, fit the solution to the problem. Small files can leave you with lots of separate datafiles which isn't necessarily a drag on performance but can be an administrative chore and can cause more wasted space due to that pesky 'end-of-datafile' free extent. Large files can fall prey to inode contention and are less portable (discuss!). Files over 2GB are best avoided unless there is a compelling reason to use them or you are certain that all of your software can handle them. People who want to set up databases larger than a terabyte will inevitably have a budget to invest in new kit and buy-in to up to date OS and software levels. Not everyone has that luxury and a lot of legacy kit doesn't like 2GB+ files. That's only my opinion but really, why play around with any area that is demonstrably strewn with bugs unless you need to? Regards, Mike Hately, Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Auto Extend
> which > parameter I need to set up to > increase the file size limit? There isn't one. On NT the filesize is limited by the type of filesystem (FAT, FAT32, NTFS, etc...). I suspect the bug in question is bug 711563, and it's fixed in the latest 7.3.4.x and 8.0.x patchsets. Yet another reason to be on the latest patchset ;) See the following metalink docs: Note: 62427.1 "2Gb or Not 2Gb - File limits in Oracle" Note: 67421.1 "ALERT: Do NOT use files >= 4Gb on NT in Oracle8" Note: 45968.1 "Oracle on NT - Some Facts, Figures and Limits" HTH, -- Anita --- [EMAIL PROTECTED] wrote: > I am running multiple Oracle 7.3-8i databases on NT. > Is there someone on > this forum who can answer my question:which > parameter I need to set up to > increase the file size limit? I have a feeling > there may not be one. > I was told by one of the super-senior Oracle people > :-) there is an Oracle > (not NT) bug with Oracle versions below 8i which > creates problems with > datafiles above 2G size. > Thank you. > > -Original Message- > Sent: Thursday, May 31, 2001 4:10 PM > To: Multiple recipients of list ORACLE-L > > > On our old AIX system we had to set a system > parameter for the file system > that allowed us to have files bigger than 2 GB. I > do not know if your > system has something like that. > > -Original Message- > Sent: Thursday, May 31, 2001 2:29 PM > To: Multiple recipients of list ORACLE-L > > > What do you mean by 'the system is not set up'. How > do you verify that? > We had problems with datafiles larger then 2 G and > just turned autoextend > off on all datafiles. > I didn't know the system may or may not be set up to > handle specific file > size limit. Is it documented? > Please explain. Thank you. > > -Original Message- > Sent: Thursday, May 31, 2001 1:08 PM > To: Multiple recipients of list ORACLE-L > > > If the system is not setup to allow files bigger > than 2 GB then the > datafiles WILL NOT EXTEND and you will get an oracle > error. > > -Original Message- > Sent: Thursday, May 31, 2001 9:31 AM > To: Multiple recipients of list ORACLE-L > > > I have taken over an Oracle database that is setup > with autoextend on the > tablespaces. Can anyone tell me what happens when > the datafiles extend > beyond 2G on Unix? > > . > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Smith, Ron L. > 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: Kevin Lange > 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: > 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: Kevin Lange > 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 b
RE: Auto Extend
I personally have 2G files and would never shy away from them. Nothing worse then having a rather huge database with 6 million files when there is really no valid excuse for it. I would have happily gone bigger then 2G as well if it were not for the Sun Omniback agent. I will do it on the HP boxes where its enabled. -Original Message- Sent: Thursday, May 31, 2001 1:31 PM To: Multiple recipients of list ORACLE-L Never say never :) I opted for 4 GB files in a larger database which is living happily on EMC Sym box. If hardware and software allow for fewer, easier managed large files...why not? This is scratching the surface of course... Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Sent: Thursday, May 31, 2001 4:10 PM To: Multiple recipients of list ORACLE-L By the way ... For your own sake . never use data files that big !!My personal opinion is multiple files of 500 Megs or less . Or, on a system that has a file limit, 1 GB files as a Max. Larger than that and you can have problems with backup software long running FTPs if you duplicate DBs ...etc. -Original Message- Sent: Thursday, May 31, 2001 2:29 PM To: Multiple recipients of list ORACLE-L What do you mean by 'the system is not set up'. How do you verify that? We had problems with datafiles larger then 2 G and just turned autoextend off on all datafiles. I didn't know the system may or may not be set up to handle specific file size limit. Is it documented? Please explain. Thank you. -Original Message- Sent: Thursday, May 31, 2001 1:08 PM To: Multiple recipients of list ORACLE-L If the system is not setup to allow files bigger than 2 GB then the datafiles WILL NOT EXTEND and you will get an oracle error. -Original Message- Sent: Thursday, May 31, 2001 9:31 AM To: Multiple recipients of list ORACLE-L I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Kevin Lange 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: 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: Kevin Lange 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: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE your
RE: Auto Extend
I am running multiple Oracle 7.3-8i databases on NT. Is there someone on this forum who can answer my question:which parameter I need to set up to increase the file size limit? I have a feeling there may not be one. I was told by one of the super-senior Oracle people :-) there is an Oracle (not NT) bug with Oracle versions below 8i which creates problems with datafiles above 2G size. Thank you. -Original Message- Sent: Thursday, May 31, 2001 4:10 PM To: Multiple recipients of list ORACLE-L On our old AIX system we had to set a system parameter for the file system that allowed us to have files bigger than 2 GB. I do not know if your system has something like that. -Original Message- Sent: Thursday, May 31, 2001 2:29 PM To: Multiple recipients of list ORACLE-L What do you mean by 'the system is not set up'. How do you verify that? We had problems with datafiles larger then 2 G and just turned autoextend off on all datafiles. I didn't know the system may or may not be set up to handle specific file size limit. Is it documented? Please explain. Thank you. -Original Message- Sent: Thursday, May 31, 2001 1:08 PM To: Multiple recipients of list ORACLE-L If the system is not setup to allow files bigger than 2 GB then the datafiles WILL NOT EXTEND and you will get an oracle error. -Original Message- Sent: Thursday, May 31, 2001 9:31 AM To: Multiple recipients of list ORACLE-L I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Kevin Lange 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: 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: Kevin Lange 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: 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: Auto Extend
On Thu, 31 May 2001, Kevin Lange wrote: > By the way ... For your own sake . never use data files that big > !!My personal opinion is multiple files of 500 Megs or less . Or, on a > system that has a file limit, 1 GB files as a Max. Larger than that and > you can have problems with backup software long running FTPs if you > duplicate DBs ...etc. Insisting upon such tiny file sizes is not practical in a large-scale enterprise environment. Systems I run on Compaq Tru64 Unix and HP-UX 11.00 (64 bit) routinely use 8 and 16 Gb. datafiles, with no problems or complaints from Veritas NetBackup. As for long-running FTPs, you have to move all the data, whether it is in a few files or many files. What does it matter if you have one FTP running for a long time, or many smaller ftps running, moving the same amount of data? Either way, you can probably achieve the appropriate degree of parallelism inthe transfer with just a few files to move. I disagree with the statement that large file sizes should be avoided. What am I supposed to do, make a 6 terabyte warehouse out of 6000 tiny 1Gb datafiles? I can't even fit the initial extent for some segments into a 1gb datafile. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Auto Extend
OK .. Never is a harsh word.Depending on your environment and in my opinion based on the environments I was in I still say never. -Original Message- Sent: Thursday, May 31, 2001 3:31 PM To: Multiple recipients of list ORACLE-L Never say never :) I opted for 4 GB files in a larger database which is living happily on EMC Sym box. If hardware and software allow for fewer, easier managed large files...why not? This is scratching the surface of course... Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Sent: Thursday, May 31, 2001 4:10 PM To: Multiple recipients of list ORACLE-L By the way ... For your own sake . never use data files that big !!My personal opinion is multiple files of 500 Megs or less . Or, on a system that has a file limit, 1 GB files as a Max. Larger than that and you can have problems with backup software long running FTPs if you duplicate DBs ...etc. -Original Message- Sent: Thursday, May 31, 2001 2:29 PM To: Multiple recipients of list ORACLE-L What do you mean by 'the system is not set up'. How do you verify that? We had problems with datafiles larger then 2 G and just turned autoextend off on all datafiles. I didn't know the system may or may not be set up to handle specific file size limit. Is it documented? Please explain. Thank you. -Original Message- Sent: Thursday, May 31, 2001 1:08 PM To: Multiple recipients of list ORACLE-L If the system is not setup to allow files bigger than 2 GB then the datafiles WILL NOT EXTEND and you will get an oracle error. -Original Message- Sent: Thursday, May 31, 2001 9:31 AM To: Multiple recipients of list ORACLE-L I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Kevin Lange 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: 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: Kevin Lange 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: Gary Weber 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
RE: Auto Extend
On our old AIX system we had to set a system parameter for the file system that allowed us to have files bigger than 2 GB. I do not know if your system has something like that. -Original Message- Sent: Thursday, May 31, 2001 2:29 PM To: Multiple recipients of list ORACLE-L What do you mean by 'the system is not set up'. How do you verify that? We had problems with datafiles larger then 2 G and just turned autoextend off on all datafiles. I didn't know the system may or may not be set up to handle specific file size limit. Is it documented? Please explain. Thank you. -Original Message- Sent: Thursday, May 31, 2001 1:08 PM To: Multiple recipients of list ORACLE-L If the system is not setup to allow files bigger than 2 GB then the datafiles WILL NOT EXTEND and you will get an oracle error. -Original Message- Sent: Thursday, May 31, 2001 9:31 AM To: Multiple recipients of list ORACLE-L I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Kevin Lange 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: 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: Kevin Lange 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: Auto Extend
By the way ... For your own sake . never use data files that big !!My personal opinion is multiple files of 500 Megs or less . Or, on a system that has a file limit, 1 GB files as a Max. Larger than that and you can have problems with backup software long running FTPs if you duplicate DBs ...etc. -Original Message- Sent: Thursday, May 31, 2001 2:29 PM To: Multiple recipients of list ORACLE-L What do you mean by 'the system is not set up'. How do you verify that? We had problems with datafiles larger then 2 G and just turned autoextend off on all datafiles. I didn't know the system may or may not be set up to handle specific file size limit. Is it documented? Please explain. Thank you. -Original Message- Sent: Thursday, May 31, 2001 1:08 PM To: Multiple recipients of list ORACLE-L If the system is not setup to allow files bigger than 2 GB then the datafiles WILL NOT EXTEND and you will get an oracle error. -Original Message- Sent: Thursday, May 31, 2001 9:31 AM To: Multiple recipients of list ORACLE-L I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Kevin Lange 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: 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: Kevin Lange 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: Auto Extend
Title: RE: Auto Extend Thanks Kimberly for correcting me. I had a feeling there was a real reason it was frowned upon in the solaris environment I used to work on (instead of 'just don't do it, I said so') but everything was so overwhemling at that time I just let it go. LK -Original Message- From: Kimberly Smith [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 2:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: Auto Extend We had an issue here where we had the Sun box to except files over 2G but got bitten in the ass quickly by it. We use HP OmniBack to backup all our Unix boxes and the agent on the Sun box could not handle the file size. So there is more then just "Can the OS handle it" to keep into account. Thankfully nothing had written to the extra portion and we were able to shrink it again. -Original Message- From: Lisa Koivu [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 10:08 AM To: Multiple recipients of list ORACLE-L Subject: RE: Auto Extend Hi Ron, do you have large files enabled on your system? What unix are you running? if large files are not enabled you're going to get an error but I can't tell you what it will be. Boy, autoextend reminds me of a monkey running around in your database. I'd never do that, but it's just my personal preference. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 10:31 AM To: Multiple recipients of list ORACLE-L Subject: Auto Extend I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: <http://www.orafaq.com> -- Author: Smith, Ron L. 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: Auto Extend
What do you mean by 'the system is not set up'. How do you verify that? We had problems with datafiles larger then 2 G and just turned autoextend off on all datafiles. I didn't know the system may or may not be set up to handle specific file size limit. Is it documented? Please explain. Thank you. -Original Message- Sent: Thursday, May 31, 2001 1:08 PM To: Multiple recipients of list ORACLE-L If the system is not setup to allow files bigger than 2 GB then the datafiles WILL NOT EXTEND and you will get an oracle error. -Original Message- Sent: Thursday, May 31, 2001 9:31 AM To: Multiple recipients of list ORACLE-L I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Kevin Lange 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: 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: Auto Extend
Never say never :) I opted for 4 GB files in a larger database which is living happily on EMC Sym box. If hardware and software allow for fewer, easier managed large files...why not? This is scratching the surface of course... Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Sent: Thursday, May 31, 2001 4:10 PM To: Multiple recipients of list ORACLE-L By the way ... For your own sake . never use data files that big !!My personal opinion is multiple files of 500 Megs or less . Or, on a system that has a file limit, 1 GB files as a Max. Larger than that and you can have problems with backup software long running FTPs if you duplicate DBs ...etc. -Original Message- Sent: Thursday, May 31, 2001 2:29 PM To: Multiple recipients of list ORACLE-L What do you mean by 'the system is not set up'. How do you verify that? We had problems with datafiles larger then 2 G and just turned autoextend off on all datafiles. I didn't know the system may or may not be set up to handle specific file size limit. Is it documented? Please explain. Thank you. -Original Message- Sent: Thursday, May 31, 2001 1:08 PM To: Multiple recipients of list ORACLE-L If the system is not setup to allow files bigger than 2 GB then the datafiles WILL NOT EXTEND and you will get an oracle error. -Original Message- Sent: Thursday, May 31, 2001 9:31 AM To: Multiple recipients of list ORACLE-L I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Kevin Lange 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: 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: Kevin Lange 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: Gary Weber 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: Auto Extend
Title: RE: Auto Extend We had an issue here where we had the Sun box to except files over 2G but got bitten in the ass quickly by it. We use HP OmniBack to backup all our Unix boxes and the agent on the Sun box could not handle the file size. So there is more then just "Can the OS handle it" to keep into account. Thankfully nothing had written to the extra portion and we were able to shrink it again. -Original Message-From: Lisa Koivu [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 31, 2001 10:08 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Auto Extend Hi Ron, do you have large files enabled on your system? What unix are you running? if large files are not enabled you're going to get an error but I can't tell you what it will be. Boy, autoextend reminds me of a monkey running around in your database. I'd never do that, but it's just my personal preference. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 10:31 AM To: Multiple recipients of list ORACLE-L Subject: Auto Extend I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Auto Extend
Title: RE: Auto Extend Hi Ron, do you have large files enabled on your system? What unix are you running? if large files are not enabled you're going to get an error but I can't tell you what it will be. Boy, autoextend reminds me of a monkey running around in your database. I'd never do that, but it's just my personal preference. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 10:31 AM To: Multiple recipients of list ORACLE-L Subject: Auto Extend I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Auto Extend
Title: RE: Auto Extend See Note:62427.1, 2Gb or Not 2Gb - File limits in Oracle http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=62427.1 -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 9:56 AM To: Multiple recipients of list ORACLE-L Subject: Re: Auto Extend "Depends" is the standard answer. Oracle can handle files over 2g, some unixes can, some unixes cannot, some say they can but cannot etc etc... To compound things, in some versions, Oracle will let the file go beyond 2g, only then to complain because the unix won't let Oracle get to the bits after 2G - thus corrupt db. Unless you're on raw, I'd recommend a ceiling of 2g on any datafile - just to be safe hth connor --- "Smith, Ron L." <[EMAIL PROTECTED]> wrote: > I have taken over an Oracle database that is setup > with autoextend on the > tablespaces. Can anyone tell me what happens when > the datafiles extend > beyond 2G on Unix? > > . > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Smith, Ron L. > 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: Auto Extend
Hi, When using autoextend always set max size and monitor. Turn off auto extend if a small possibility exists to do so. Check if your OS has large file size enabled and there won't be any problems. jack "Smith, Ron L." To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) om> Subject: Auto Extend Sent by: [EMAIL PROTECTED] om 31-05-2001 16:31 Please respond to ORACLE-L I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst & Young. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst & Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst & Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is availa
Re: Auto Extend
"Depends" is the standard answer. Oracle can handle files over 2g, some unixes can, some unixes cannot, some say they can but cannot etc etc... To compound things, in some versions, Oracle will let the file go beyond 2g, only then to complain because the unix won't let Oracle get to the bits after 2G - thus corrupt db. Unless you're on raw, I'd recommend a ceiling of 2g on any datafile - just to be safe hth connor --- "Smith, Ron L." <[EMAIL PROTECTED]> wrote: > I have taken over an Oracle database that is setup > with autoextend on the > tablespaces. Can anyone tell me what happens when > the datafiles extend > beyond 2G on Unix? > > . > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Smith, Ron L. > 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: Auto Extend
If the system is not setup to allow files bigger than 2 GB then the datafiles WILL NOT EXTEND and you will get an oracle error. -Original Message- Sent: Thursday, May 31, 2001 9:31 AM To: Multiple recipients of list ORACLE-L I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Kevin Lange 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).