| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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: rlsmith_at_kmg.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gary Weber
INET: gweber_at_cji.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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). Received on Thu May 31 2001 - 17:07:48 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |