pctincrease for system tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: pctincrease for system tablespace

  1. #1
    Join Date
    Jan 2001
    Posts
    16
    Should the tablespace SYSTEM be of 50% or O% pctincrease and why?

    Thanks in advance.


    __

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Since we don't have much control over the objects in the SYSTEM tablespace, I like to keep at PCTINCREASE 50.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2000
    Posts
    7

    System tablespaces

    System tablespace should be more than 0 because we will dropping and creating so many objects. There will be lot of space defragmentation. So if pctincrease percentage greater than 1 system will coalese it automatically.



    I hope i have clarified

  4. #4
    Join Date
    Aug 2000
    Posts
    194
    Another reason could be, most of the system tables are created with a small INITIAL size. PCTINCREASE of 50% will help to keep the number of extents less.

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well by default itīs 50 anyway and there is not much point changing it afterwards since the segments are already created with that pct increase value, even you change at tablespace level the segments will still have pct increase 50

  6. #6
    Join Date
    Sep 2000
    Posts
    155

    Perhaps, you could use the new feature LOCALLY MANAGED TABLESPACE for SYSTEM tablespace as well if you are using Oracle 8.1.5 or greater ?

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I do not think this is supported

  8. #8
    Join Date
    Sep 2000
    Posts
    155

    This is right out of Oracle Documentation:


    For the SYSTEM tablespace, you can specify EXTENT MANGEMENT LOCAL in the CREATE DATABASE command. If the SYSTEM tablespace is locally managed, other tablespaces in the database can be dictionary-managed but you must create all rollback segments in locally-managed tablespaces.


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