Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2003
    Posts
    70

    Talking Unanswered: Datafile extending

    Dear All,
    I would want to know while creating a tablespace is it a good idea to give AUTOEXTEND ON clause. Or instead whenever necessary a datafile can be added whenever space issue comes.

    Which approach is good and why?

    Thanks in advance
    qA

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Personally, I set to autoextend. With the cheap price of drive space, there
    is really no longer any excuses for being strapped for space. I do keep and eye on the datafile sizes and set the autoextend to a relatively small size (depending on the tables and their sizes). Datafile extensions (physical drive writting) is expensive in that Oracle must "touch" every new data block before it will complete the file extensions. ... Just 1 opinion

    HTH
    Gregg

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Several yeears ago, while running Oracle 7 on Digital Alpha Server with VERY expensive hard disks, made us extend datafiles when necessary. But now, when disks are really cheap (just like Gregg said), there's no special reason NOT to have autoextend on.

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    Just don't set that for TEMP or UNDO
    Those two tablespaces should be reusing the space in themselves.

    If you set autoextend on then also create a shell-script to monitor your
    filesystem space. So, when your filesystem reaches 80%-85% your will
    get paged and can do something about it before really bad things happen.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Use autoextend, but setup a max size. With unlimited extend, you can get a file that is too big for your OS to access or can fill a volume and cause other applications to hang or blowup. Even oracle can hang if it can't write archivelogs or it's alert file.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  6. #6
    Join Date
    Jul 2003
    Posts
    2,296
    Quote Originally Posted by beilstwh
    Use autoextend, but setup a max size. With unlimited extend, you can get a file that is too big for your OS to access or can fill a volume and cause other applications to hang or blowup. Even oracle can hang if it can't write archivelogs or it's alert file.
    good idea there.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  7. #7
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    I'm with beilstwh on this.

Posting Permissions

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