Depends on the situation and what you call a "difference"

From a performance perspective, it doesn't matter how many files you
have, what matters is how many disk drive you can put to work
simultaneously. Striping one large file over many drives is probably
the most efficient approach. If you cannot stripe the file across
multiple disks, putting smaller files on separate drives is an
alternative, but you will likely run into situations where the "hot"
blocks are in one of these files, so you can spend a lot of time on I/O
balancing.

From a recovery perspective, having reasonable and standard file sizes
is a good thing. If you had a failure and you have one 100 GB data
file, you have to restore the entire file from tape. If you only lost a
2 or 4 GB file, on the other hand, you don't have to worry. If files
are standard sizes, it also makes moving them around easier, which is
quite helpful when a RAID array fails and you need to spread the lost
files over your other drives.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: Carlos Barrera
[mailto:oracledba-ezmlmshield-x97762876.[Email address protected]
Sent: Friday, October 29, 2004 5:01 PM
To: LazyDBA Discussion
Subject: tablespaces

Hi all,

Based on your experience, is there a difference if I use only 1
datafile
or 10 or 20 or n (all on the same disk) for a single tablespace?

Also is there a benefit if the datafiles for 1 tablespace are on
different disks?

Oracle version is 8.0.5.


Regards.



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html






Oracle LazyDBA home page