System tablespace size for repositories
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: System tablespace size for repositories

  1. #1
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    Is there a recommended size of the System tablespace for a database that will be used for RMAN catalog *and* OEM Management Server?
    Don't blame me, I'm from Red Sox Nation.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Why would you want to put them in the system tablespace. I would suggest that you create a seperate tablespace for them individually. This would be a good practice.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    I misrepresented my question - sorry. The repositories would indeed be in seperate tablespaces.

    I guess my real question is: What is the smallest size for the SYSTEM tablespace?

    I only mentioned the repositories because I wanted to tell what I would be using the database for.

    Thanks.
    Don't blame me, I'm from Red Sox Nation.

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    I guess my real question is: What is the smallest size for the SYSTEM tablespace?
    Depends on the Orcale version and the scrips you run after creating the database. For Oracle 8i, the minimum is 50M for the system tablespace. Your system tablespace should never reach the maximum, because then your DB may get corrupted. Create it with MAXEXTENTS UNLIMITED and let the MAXSIZE be big enough to accomodate all possible additions to the tablespace.

    Read the following if you dig Oracle internals. In Oracle8i the default storage clause is internalized. There is an internal algorithm which sets the initial and next for the default storage on the SYSTEM tablespace to a minimum of 10k or a multiple of Oracle db_block_size, whichever is greater. For example, with an 8k blocksize the initial and next are set to 16k. If the db_block_size=2048, the initial and next are 10k. If the db_block_size=4096, the initial and next are 12k. If db_block_size= 16384, the initial = 32k and next = 16k.

    When I create a database in 8i, I do the at once the following:

    ALTER TABLESPACE SYSTEM DEFAULT STORAGE
    (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 50);

    ALTER TABLESPACE SYSTEM MINIMUM EXTENT 64K;



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