At some places, midrange storage performed with SAN environments
where the ability to identify multiple drives to place files is not
controllable by the midrange or DBA. It is a virtual type of storage and
having or knowing what drives are used for your files is almost impossible.
Bob W.
-----Original Message-----
From: Justin Cave (DDBC)
[mailto:oracledba-ezmlmshield-x66088950.[Email address protected]
Sent: Friday, October 29, 2004 5:21 PM
To: LazyDBA Discussion
Subject: RE: tablespaces
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
--------
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
-------------------------------------------------------------------------------------------
***National City made the following annotations
-------------------------------------------------------------------------------------------
This communication is a confidential and proprietary business communication. It is intended solely for the use of the designated recipient(s). If this communication is received in error, please contact the sender and delete this communication.
===========================================================================================
Oracle LazyDBA home page