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

Thread: HOw can change pctincrease

  1. #1
    Join Date
    Jun 2001
    Posts
    150
    How can i change the pctincrease of tablespaces to 1

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    There is no need to have a tablespace with pctincrease 1. Are you after SMON coalesing free space every 5th minute?


  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    which consumes resources

    but if you are happy with it then

    alter tablespace system default storage(pctincrease 1)

  4. #4
    Join Date
    Jun 2001
    Posts
    150
    yes i want smon to coalesce the tablespace. As tablespaces get fragmented so i want the smon to coalesce it. Is that a bad idea? what is the alternative to get fragmented space back?
    Cheers
    UKDBA

  5. #5
    Join Date
    Oct 2000
    Posts
    467
    alter tablespace static_idx default storage(pctincrease 1);
    Vinit

  6. #6
    Join Date
    Oct 2000
    Posts
    467
    seems like i was a bit late .
    Vinit

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well coalesce uses quite a lot of resources that is why

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