!! 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).
