Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: having multiple datafiles per tablespace vs. one datafile per tablespace

RE: having multiple datafiles per tablespace vs. one datafile per tablespace

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Sat, 16 Sep 2000 00:31:01 +1000
Message-Id: <10620.117097@fatcity.com>


Hi Babu,

The potential drawbacks of having multiple datafiles are trivial compared to the potential benefits.

On most platforms when you issue a CREATE TABLESPACE command with multiple datafiles, those datafiles will be "zeroed" in parallel by slave threads. Even on platforms that do not support this, you can do multiple ALTER TABLESPACE ADD DATAFILE commands in parallel. Therefore multiple datafiles can make tablespace creation much faster.

For file system based databases, having multiple datafiles may reduce the risk of contention for the operating system's datafile read/write locks (inode locks).

Having multiple datafiles per tablespace facilitates the adoption of a uniform datafile size policy, which in turn facilitates disk load rebalancing.

Finally, I answered a related question on Ixora Answers a few weeks ago, and you may find that answer relevant. Look for the answer headed "Is AUTOEXTEND OK?" at http://www.ixora.com.au/q+a/0008/30150113.htm.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

@

@ Going to OpenWorld?
@ Catch the Ixora performance tuning seminar too!
@ See http://www.ixora.com.au/seminars/ for details.

-----Original Message-----
From: babu.nagarajan_at_iflexsolutions.com
[mailto:babu.nagarajan_at_iflexsolutions.com] Sent: Friday, 15 September 2000 22:20
To: ORACLE-L_at_fatcity.com; oracledba_at_lazydba.com Subject: having multiple datafiles per tablespace vs. one datafile per tablespace

Hi

Could any one point out the advantages/disadvantages of having multiple datafiles for a tablespace as against having one datafile per tablespace? Received on Fri Sep 15 2000 - 09:31:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US