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: ORACLE-L_at_fatcity.com; cspence_at_FuelSpot.com

>> 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:cspence_at_FuelSpot.com]
> 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: cspence_at_FuelSpot.com

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