Setting pctincrease 0 on a tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Setting pctincrease 0 on a tablespace

  1. #1
    Join Date
    Apr 2000
    Location
    Boston, MA 01803
    Posts
    24

    Question

    Hi,

    Is there ever an advantage to setting pctincrease to 0 on a tablespace? Does it indeed prevent auto-coalesce on a tablespace? Thoughts on the subject?

    Thanks in Advance,
    Tracy

    ps
    I'm building the aforementioned tablespaces in a warehouse environment.

  2. #2
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    I believe it does stop SMON from autocoalescing. Set it to 1 instead.

  3. #3
    Join Date
    Mar 2001
    Posts
    188
    the advantage of set pctincrease to 0 is that the tablespace will not fragmented. This means if you delete some rows and syou will insert new rows. This coun't take this space where the older (deleted) rows were.

    So the advantage is that the tablespace will not fragmented and so the db must not search space were new rows will insert. So all new rows will insert into spaces of the tablespace where old rows are deleted.

    Regards
    Thomas

  4. #4
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    The changes in pctincrease will not take effect until you shutdown and startup again.

    That is, going from 0 to 1 without a reboot won't result in an automatic coalesce.
    David Knight
    OCP DBA 8i, 9i, 10g

  5. #5
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    When u set pctincrease to 0 at tablespace level Oracle(SMON) will not coalesce the tablespace automatically.
    Oracle recommends a setting of 0 as a way to minimize fragmentation and avoid the possiblity of very large temporary segments during processing.
    In case of any help please be free to ask me at rohitsn@altavista.com

    regards,
    Rohit nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

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