TEMP Tablespace related question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: TEMP Tablespace related question

  1. #1
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620

    Question

    Hi all,

    We are on 81730/W2K.

    I have a question related to the TEMP Tablespace.

    What should be the configuration of TEMP tablespace?

    1. Should it be defined as TEMPORARY or PERMANENT?
    2. Should it be defined as Locally Managed or Dictionary managed?

    What is the best configuration for TEMP tablespace to achieve the best performance.

    Thanks in Adv.

    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    temporary of coz
    locally managed of coz

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Sam,
    A locally managed tablespace might appear to grow a lot but is better for performance as no recursive calls need to made for extent allocation/deallocation(as would be the case should you choose it to be managed by the dictionary). With locally(as the name suggests) you do it locally/internally as compared to externally/by the dictinary.

    For syntax etc
    dictionary & locally managed




    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

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