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

Thread: Datafiles..

  1. 03-18-2003, 01:50 AM #1
    fordikon
    fordikon is offline Member
    Join Date
    Apr 2001
    Posts
    126

    Post Datafiles..

    For the tablespace size of > 10GB how many datafiles are recommended in oracle9i/win2k.
    Reply With Quote Reply With Quote
  2. 03-18-2003, 01:56 AM #2
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

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

    regards
    Hrishy
    Reply With Quote Reply With Quote
  3. 03-18-2003, 01:58 AM #3
    fordikon
    fordikon is offline Member
    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.
    Reply With Quote Reply With Quote
  4. 03-18-2003, 01:59 AM #4
    hrishy
    hrishy is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
  6. 03-18-2003, 02:01 AM #5
    akhadar
    akhadar is offline Advisor
    Join Date
    May 2001
    Posts
    736
    Definitely u have performance improvement if the datafiles on different disk controllers.
    Reply With Quote Reply With Quote
  7. 03-18-2003, 02:10 AM #6
    fordikon
    fordikon is offline Member
    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?.
    Reply With Quote Reply With Quote
  8. 03-18-2003, 02:52 AM #7
    dasari98's Avatar
    dasari98
    dasari98 is offline Member
    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
    Reply With Quote Reply With Quote
  9. 03-18-2003, 04:06 AM #8
    nabeel's Avatar
    nabeel
    nabeel is offline Member
    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!
    ====================================================
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width