Estaimate Size of Temp-Tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Estaimate Size of Temp-Tablespace

  1. #1
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448

    Estaimate Size of Temp-Tablespace

    Oracle EE 8.1.7.3.50

    Hi,
    How could i estimate the max Size of the temp-Tablspace?

    - Size like the largest Index-Segment?
    - Size like the largest Table ?

    Thanks for help
    Orca


  2. #2
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    Back in the dark ages of V6 I developped a rule of thumb that the TEMP tablespace should be at least twice the size of the largest object in the database (table or index.) Depending on usage, it might have to be larger (and might be smaller), but that was the starting point. It was based on users doing full table sorts, etc., in a multiple user environment.

    I still use it as a starting point, but it is less vital these days with sort areas, undo tablespace etc. and OLTP rather than DSS. Less vital, but causes less problems.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  3. #3
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Thanks Joseph;

    Our Environment is OLTP, but due to long-running batch-jobs it's like DSS too. Thank you for the hint and be blessed;

    Orca

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