Datafiles..
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Datafiles..

  1. #1
    Join Date
    Apr 2001
    Posts
    126

    Post Datafiles..

    For the tablespace size of > 10GB how many datafiles are recommended in oracle9i/win2k.

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    I personally like oracle files of size less than 2Gb..

    regards
    Hrishy

  3. #3
    Join Date
    Apr 2001
    Posts
    126
    is this the limitation of DB /OS ? or recommended size?
    can the datafile be spanned accross diff disks for perf.

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    some unixes have problems with files greater that 2GB..but i take this as a general rule for all Unixes inculding NT..they are also easier to backup..i can backup them up in parallel..

    regards
    Hrishy

  5. #5
    Join Date
    May 2001
    Posts
    736
    Definitely u have performance improvement if the datafiles on different disk controllers.

  6. #6
    Join Date
    Apr 2001
    Posts
    126
    will there be any performance bottleneck if we have more datafiles for single tablespace? is it recommended to give auto extend or manually extend the size. what are the precautions to be taken when giving autoextend?.

  7. #7
    Join Date
    Apr 2002
    Location
    Bangalore
    Posts
    47
    Originally posted by fordikon
    will there be any performance bottleneck if we have more datafiles for single tablespace? is it recommended to give auto extend or manually extend the size. what are the precautions to be taken when giving autoextend?.

    I don't think there will be any bottle necks if u have more datafiles.
    Autoextend is fine but take care to give a max limit.Never give unlimited.Also check for the os limitations

    Cheers
    Murali

  8. #8
    Join Date
    Nov 1999
    Location
    Kuwait
    Posts
    122
    Originally posted by fordikon
    will there be any performance bottleneck if we have more datafiles for single tablespace? is it recommended to give auto extend or manually extend the size. what are the precautions to be taken when giving autoextend?.
    There will be no bottlenect if you have more datafiles for a single TS, assure that you have span all the Datafile on different disk to avoid I/O, The size of each datafile is OS depanded but dont forget to consider the DBWR Average scan depth.

    Auto extend feature will prevent any error which could occor during transaction in case of lack of space, if autoextent is off you have to manually extend the size which could coz delay. If Autoextend is on then maintain the data growth rate and disk space.

    Hope it helps..
    NK
    ====================================================
    Stand up for your principles even if you stand alone!
    ====================================================

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