Results 1 to 3 of 3

Thread: Dbspacestemp

  1. #1
    Join Date
    Mar 2004

    Question Unanswered: Dbspacestemp

    I' have to add temporary DBspaces , but I don't know what size should I assign.
    What's an standard size for a DBSpace?
    For a Chunk?
    For a Temporary Dbspace?

    Should I just add ones or several temporary Dbspaces?

    The information in the ONCONFIG FILE
    ROOTNAME rootdbs # Root dbspace name
    ROOTSIZE 51200 # Size of root dbspace (Kbytes
    # Physical Log Configuration
    PHYSDBS rootdbs # Location (dbspace) of physical log
    PHYSFILE 2000 # Physical log file size (Kbytes)
    # Logical Log Configuration
    LOGFILES 8 # Number of logical log files
    LOGSIZE 2000 # Logical log size (Kbytes)

    I would appreciate an orientation, or (and Better) an example,
    Thanks, Marce

  2. #2
    Join Date
    Aug 2003

    The size depends upon your database, how big your tables will grow over a period of time. All things need to be taken in to account. You create a temp dbspace with 20 mb for start and add more chunks as it grows. Also make sure that your physical & logical logs are is seperate dbspaces.



  3. #3
    Join Date
    Feb 2004
    Thumb rule : Try to have 25% the number of total data dbspaces and make sure these are on seperate spindles and not mirrored.
    Reason : The more you have , the more the temp tables are parallelized and with mirroring turned off, you gain that little grain of performance and keeping them at seperate spindles gives you a more balanced i/o.

    This is ONLY for the temporary dbspace.

    Most common mistake : don't forget to create them with the "-t " option and plug them into the "DBSPACETEMP" parameter.

    As for the chunk size , the max you could go is 2Gb , unless you use the 9.x versions.

    Normally for sizing the dbspaces, look at how many different spindles are allocated for the database, make that many dbspaces and make sure the volumes are striped.


Posting Permissions

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