RE: Tablespace (datafile reducing)
!! Please do not post Off Topic to this List !! Having too many datafiles is not good for performance, updating datafile headers during checkpointing. I disagree, unless you have an unreasonable amount, there is minor almost not noticeable difference. Tests have been done on many databases with 3500+ data files and shown the difference to be insignificant. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, September 13, 2001 8:55 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Kishore, Having too many datafiles is not good for performance, updating datafile headers during checkpointing. If you are on 8i you can create a 2GB tablespace, and use the alter table move command to move all the tables in that tablespace to the new 2GB tablespace. All associated indexes will become unusable, so make sure you alter index rebuild ... If the tablespace has indexes rather than tables then you could do a alter index rebuild ... to move them to the new tablespace. If you are not on 8i then you can use export/ import. Export all tables in the tablespace, Drop the tables, Drop the tablespace, Recreate new tablespace (same name) with single datafile, Import all tables Regards Suhen !! Please do not post Off Topic to this List !! Hello DBAs I have a tablespace , who has 10 datafiles of 200MB each, it was here before I even joined. I was thinking for the contention and want to combine them all to one single large datafile of 2gig. How do I get rid off all those datafiles and ghet them in one large datafiles?? Any help in this regard Thank you very much Kishore __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kishore 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: Suhen Pather 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: Tablespace (datafile reducing)
!! Please do not post Off Topic to this List !! Generally more smaller data files is better than fewer larger ones. There is no performance problem with having 10 200Mb data files rather than 1 2gb data file. In fact, using 10 200mb data files will help a little when it comes to file locking. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, September 13, 2001 8:27 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Hello DBAs I have a tablespace , who has 10 datafiles of 200MB each, it was here before I even joined. I was thinking for the contention and want to combine them all to one single large datafile of 2gig. How do I get rid off all those datafiles and ghet them in one large datafiles?? Any help in this regard Thank you very much Kishore __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kishore 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: Tablespace (datafile reducing)
!! Please do not post Off Topic to this List !! Tests have been done on many databases with 3500+ data files and shown the difference to be insignificant. Chris, Can you pl point me to the doc/web site etc. where this is reported. I am having to deal with such an issue with one of my databases that has less than 500 files, but the number is growing rapidly.. Thanks. - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 8:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: Tablespace (datafile reducing) !! Please do not post Off Topic to this List !! Having too many datafiles is not good for performance, updating datafile headers during checkpointing. I disagree, unless you have an unreasonable amount, there is minor almost not noticeable difference. Tests have been done on many databases with 3500+ data files and shown the difference to be insignificant. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, September 13, 2001 8:55 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Kishore, Having too many datafiles is not good for performance, updating datafile headers during checkpointing. If you are on 8i you can create a 2GB tablespace, and use the alter table move command to move all the tables in that tablespace to the new 2GB tablespace. All associated indexes will become unusable, so make sure you alter index rebuild ... If the tablespace has indexes rather than tables then you could do a alter index rebuild ... to move them to the new tablespace. If you are not on 8i then you can use export/ import. Export all tables in the tablespace, Drop the tables, Drop the tablespace, Recreate new tablespace (same name) with single datafile, Import all tables Regards Suhen !! Please do not post Off Topic to this List !! Hello DBAs I have a tablespace , who has 10 datafiles of 200MB each, it was here before I even joined. I was thinking for the contention and want to combine them all to one single large datafile of 2gig. How do I get rid off all those datafiles and ghet them in one large datafiles?? Any help in this regard Thank you very much Kishore -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: Tablespace (datafile reducing)
!! Please do not post Off Topic to this List !! Chris, Are these tests results published someplace? Tests have been done on many databases with 3500+ data files and shown the difference to be insignificant. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, September 14, 2001 9:50 AM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Having too many datafiles is not good for performance, updating datafile headers during checkpointing. I disagree, unless you have an unreasonable amount, there is minor almost not noticeable difference. Tests have been done on many databases with 3500+ data files and shown the difference to be insignificant. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, September 13, 2001 8:55 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Kishore, Having too many datafiles is not good for performance, updating datafile headers during checkpointing. If you are on 8i you can create a 2GB tablespace, and use the alter table move command to move all the tables in that tablespace to the new 2GB tablespace. All associated indexes will become unusable, so make sure you alter index rebuild ... If the tablespace has indexes rather than tables then you could do a alter index rebuild ... to move them to the new tablespace. If you are not on 8i then you can use export/ import. Export all tables in the tablespace, Drop the tables, Drop the tablespace, Recreate new tablespace (same name) with single datafile, Import all tables Regards Suhen !! Please do not post Off Topic to this List !! Hello DBAs I have a tablespace , who has 10 datafiles of 200MB each, it was here before I even joined. I was thinking for the contention and want to combine them all to one single large datafile of 2gig. How do I get rid off all those datafiles and ghet them in one large datafiles?? Any help in this regard Thank you very much Kishore __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kishore 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: Suhen Pather 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). -- 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
RE: Tablespace (datafile reducing)
!! Please do not post Off Topic to this List !! There is no performance problem with having 10 200Mb data files rather than 1 2gb data file. In fact, using 10 200mb data files will help a little when it comes to file locking. and recovery.. -Original Message- Spence Sent: Friday, September 14, 2001 14:50 To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Generally more smaller data files is better than fewer larger ones. There is no performance problem with having 10 200Mb data files rather than 1 2gb data file. In fact, using 10 200mb data files will help a little when it comes to file locking. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, September 13, 2001 8:27 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Hello DBAs I have a tablespace , who has 10 datafiles of 200MB each, it was here before I even joined. I was thinking for the contention and want to combine them all to one single large datafile of 2gig. How do I get rid off all those datafiles and ghet them in one large datafiles?? Any help in this regard Thank you very much Kishore __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kishore 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: Tablespace (datafile reducing)
!! Please do not post Off Topic to this List !! Someone posted a test they did from this list, some reason I believe it was John, but I can't remember 100%. If the person who did this test on the list please come forward, I remember this discussion, but I may even do it on one of my test boxes at home to simulate it again. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Friday, September 14, 2001 9:57 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Tests have been done on many databases with 3500+ data files and shown the difference to be insignificant. Chris, Can you pl point me to the doc/web site etc. where this is reported. I am having to deal with such an issue with one of my databases that has less than 500 files, but the number is growing rapidly.. Thanks. - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 8:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: Tablespace (datafile reducing) !! Please do not post Off Topic to this List !! Having too many datafiles is not good for performance, updating datafile headers during checkpointing. I disagree, unless you have an unreasonable amount, there is minor almost not noticeable difference. Tests have been done on many databases with 3500+ data files and shown the difference to be insignificant. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, September 13, 2001 8:55 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Kishore, Having too many datafiles is not good for performance, updating datafile headers during checkpointing. If you are on 8i you can create a 2GB tablespace, and use the alter table move command to move all the tables in that tablespace to the new 2GB tablespace. All associated indexes will become unusable, so make sure you alter index rebuild ... If the tablespace has indexes rather than tables then you could do a alter index rebuild ... to move them to the new tablespace. If you are not on 8i then you can use export/ import. Export all tables in the tablespace, Drop the tables, Drop the tablespace, Recreate new tablespace (same name) with single datafile, Import all tables Regards Suhen !! Please do not post Off Topic to this List !! Hello DBAs I have a tablespace , who has 10 datafiles of 200MB each, it was here before I even joined. I was thinking for the contention and want to combine them all to one single large datafile of 2gig. How do I get rid off all those datafiles and ghet them in one large datafiles?? Any help in this regard Thank you very much Kishore -- 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: Tablespace (datafile reducing)
!! Please do not post Off Topic to this List !! Datafile sizing is also dependent on the size of your db. I use 10gb datafile size's for a 1tb database. [EMAIL PROTECTED] 09/14/01 09:50AM !! Please do not post Off Topic to this List !! Generally more smaller data files is better than fewer larger ones. There is no performance problem with having 10 200Mb data files rather than 1 2gb data file. In fact, using 10 200mb data files will help a little when it comes to file locking. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, September 13, 2001 8:27 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Hello DBAs I have a tablespace , who has 10 datafiles of 200MB each, it was here before I even joined. I was thinking for the contention and want to combine them all to one single large datafile of 2gig. How do I get rid off all those datafiles and ghet them in one large datafiles?? Any help in this regard Thank you very much Kishore __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kishore 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). -- 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: Tablespace (datafile reducing)
!! Please do not post Off Topic to this List !! I know a few people (actually on the LazyDBA list) have done tests and each time they have said the checkpoint time has been insignificantly altered. I cannot say I have done these tests, and go by the theory of using smaller data files rather than larger ones for portability and locking reasons. I never see any problems with checking pointing due to size. I hope some of the people who have played with this are around and have the results. I do not have anything official to offer on this as I am merely going off what other people have said that have tried it, and the experiences I have had (although not with that many data files). If no one steps up, I may put together some test environment to put concrete fact either way. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Friday, September 14, 2001 10:50 AM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Chris, Are these tests results published someplace? Tests have been done on many databases with 3500+ data files and shown the difference to be insignificant. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, September 14, 2001 9:50 AM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Having too many datafiles is not good for performance, updating datafile headers during checkpointing. I disagree, unless you have an unreasonable amount, there is minor almost not noticeable difference. Tests have been done on many databases with 3500+ data files and shown the difference to be insignificant. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, September 13, 2001 8:55 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Kishore, Having too many datafiles is not good for performance, updating datafile headers during checkpointing. If you are on 8i you can create a 2GB tablespace, and use the alter table move command to move all the tables in that tablespace to the new 2GB tablespace. All associated indexes will become unusable, so make sure you alter index rebuild ... If the tablespace has indexes rather than tables then you could do a alter index rebuild ... to move them to the new tablespace. If you are not on 8i then you can use export/ import. Export all tables in the tablespace, Drop the tables, Drop the tablespace, Recreate new tablespace (same name) with single datafile, Import all tables Regards Suhen !! Please do not post Off Topic to this List !! Hello DBAs I have a tablespace , who has 10 datafiles of 200MB each, it was here before I even joined. I was thinking for the contention and want to combine them all to one single large datafile of 2gig. How do I get rid off all those datafiles and ghet them in one large datafiles?? Any help in this regard Thank you very much Kishore __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kishore 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: Suhen Pather 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:
Re: Tablespace (datafile reducing)
Chris, "Generally more smaller data files is better than fewer larger ones." Can you pl let me know if there is any paper or something throwing light on this. Thanks Anjan Gene Sais wrote: !! Please do not post Off Topic to this List !! Datafile sizing is also dependent on the size of your db. I use 10gb datafile size's for a 1tb database. >>> [EMAIL PROTECTED] 09/14/01 09:50AM >>> !! Please do not post Off Topic to this List !! Generally more smaller data files is better than fewer larger ones. There is no performance problem with having 10 200Mb data files rather than 1 2gb data file. In fact, using 10 200mb data files will help a little when it comes to file locking. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, September 13, 2001 8:27 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Hello DBAs I have a tablespace , who has 10 datafiles of 200MB each, it was here before I even joined. I was thinking for the contention and want to combine them all to one single large datafile of 2gig. How do I get rid off all those datafiles and ghet them in one large datafiles?? Any help in this regard Thank you very much Kishore __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kishore 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). -- 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: Tablespace (datafile reducing)
!! Please do not post Off Topic to this List !! And I have built TB+ sized databases using no datafiles larger than 2 GB. At this level, larger files are worthy of consideration, but they are certainly not required - or even critical. It depends... -Don Granaman [OraSaurus - Honk if you remember UFI!] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 14, 2001 10:25 AM !! Please do not post Off Topic to this List !! Datafile sizing is also dependent on the size of your db. I use 10gb datafile size's for a 1tb database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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: Tablespace (datafile reducing)
!! Please do not post Off Topic to this List !! Create a new tablespace and move the objects to it using alter table move or imp/exp. If you need to use the same tablespace then you need to export, drop tablespace, recreate with one datafile, import. - E -Original Message- From: Kishore [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 13, 2001 5:27 PM To: Multiple recipients of list ORACLE-L Subject: Tablespace (datafile reducing) !! Please do not post Off Topic to this List !! Hello DBAs I have a tablespace , who has 10 datafiles of 200MB each, it was here before I even joined. I was thinking for the contention and want to combine them all to one single large datafile of 2gig. How do I get rid off all those datafiles and ghet them in one large datafiles?? Any help in this regard Thank you very much Kishore __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kishore 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). -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Tablespace (datafile reducing)
!! Please do not post Off Topic to this List !! Kishore, Having too many datafiles is not good for performance, updating datafile headers during checkpointing. If you are on 8i you can create a 2GB tablespace, and use the alter table move command to move all the tables in that tablespace to the new 2GB tablespace. All associated indexes will become unusable, so make sure you alter index rebuild ... If the tablespace has indexes rather than tables then you could do a alter index rebuild ... to move them to the new tablespace. If you are not on 8i then you can use export/ import. Export all tables in the tablespace, Drop the tables, Drop the tablespace, Recreate new tablespace (same name) with single datafile, Import all tables Regards Suhen !! Please do not post Off Topic to this List !! Hello DBAs I have a tablespace , who has 10 datafiles of 200MB each, it was here before I even joined. I was thinking for the contention and want to combine them all to one single large datafile of 2gig. How do I get rid off all those datafiles and ghet them in one large datafiles?? Any help in this regard Thank you very much Kishore __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kishore 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: Suhen Pather 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).