I don't think the oversized file will hurt your database in any way. The cost will be in increased backup time, and of course, the total waste of 500M of disk space for the life of the database.
If this is a development database, and your developers are busy writing stored packages, then leaving extra space in the system tablespace is a good idea, as they will be using that space (although 500M is a LOT!). If it is a production database, I would shrink it back down so that there is about 100Meg of available space in the tablespace. Anything more than that is a waste. Hope this helps. Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Sunday, January 27, 2002 4:55 AM To: Multiple recipients of list ORACLE-L A fellow DBA working with me resized the System tablespace to double its size i.e. from 500MB to 1GB: I dont like the practise of just arbitrarily doubling a datafile size and it sitting empty for years, but apart from extra backup time , would this large oversized datafile upset the database engine in any way, or be inefficient at a database or o/s level: I suspect certain areas but to busy right now RTFM. p.s. 8.1.6 / solaris 2.8 -- 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: Mercadante, Thomas F 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).
