Why is there no max_extents value for temporary tablespace?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Why is there no max_extents value for temporary tablespace?

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Posts
    257
    Hi,

    When I do the query below, there is no value for max_extents for the temporary tablespace. Why is that? Does it mean there could be unlimited number of extents in a temporary sort segment?

    Thank you!
    -------------------------

    SQL>select tablespace_name ts, initial_extent init,
    next_extent next, min_extents min, max_extents max
    from dba_tablespaces
    where tablespace_name = 'TEMP'

    TS INIT NEXT MIN MAX
    ------ ---------- ---------- ---------- ----------
    TEMP 65536 65536 1

  2. #2
    Join Date
    Jun 2002
    Posts
    73
    Yes as far as i think when sorting exceeds SORT_ARE_SIZE
    and user has been asigned temporary tablespace then only one segment is created in the temp tablespace and it will do sorting for all users untill the instance shutdown..The MAX_EXTENTS are unlimited (to the size of temp tablespace).
    Please anyone if i am wrong.
    You cannot succeed if you fear to face challenges.
    MAS
    BE(CS) , OCP 8/8i.



  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    temp tablespaces will have unlimited extents which is fine since sort segments are shared

    datafile growth is controlled by autoextend on/off

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