Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    1,074

    Unanswered: Determining datafile size for Temp Tablespace

    Is there a rule of thumb for determining the size of the temporary tablespace, or at least a common starting value? And do you set set quotas, and if so, how do you determine the avg setting?

    -Thanks
    Chuck

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    No, there is no rule of thumb.
    It depends on how much data you have, and how many sorts are done with that data and how big they are.

    Try to just create a tempfile (or datafile) with the AUTOEXTEND enabled. You will see how big it grows.
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Chuck,
    I agree with Ruudboy... There is no real "rule of Thumb"...
    As stated, ensure you have autoextend turned on.. and the DEFAULT NEXT_EXTENT should be equal to the sort_area_size parameter.

    If you know roughly the amount of sorts and group by's then you can "ballpark" the size. Otherwise, start with something reasonable
    (ie, 100mg, 200mg, etc ...) depending on the size of the database and
    the number of users and the type of application ...

    HTH
    Gregg

Posting Permissions

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