Datafiles in Tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Datafiles in Tablespace

  1. #1
    Join Date
    Mar 2001
    Posts
    109
    Does any body know what the difference between defining one datafile and defining more than one datafiles in a tablespace is, assuming the tablespace sizes in two cases are the same.

    Thanks.
    zm

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    No diffrence if all the datafiles are going to ne in one location, except easier to deal with 2GB datafile for managing than 20 100MB datafiles.

    Makes diffrence if you are going to keep these no of datafiles in differenct location from the I/O perspective. The time taking to bring block from datafile to buffer will be fast hence I/O will be efficient.

    Hope this helps.
    Reddy,Sam

  3. #3
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    One dbf per ts will also make administration easy and also in certain cases of db recovery.

  4. #4
    Join Date
    Oct 2000
    Posts
    467
    One doubt..If the Datafile is big and single ..then there can be lot of I/O but if there are 2 datafiles then it can be evenly distributed to minimize I/O across disks.


    Cheers
    Vinit

  5. #5
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    True, unless if the hot segments are relocated to a different ts.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width