DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: empty temp tablespace

  1. #1
    Join Date
    Oct 2000
    Posts
    90
    Is there a query that can help me determine if my temp tablespace is empty or not? If there is can any one show me?

    Thank you,
    dorothy

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    The TEMP tablespace is used whe memory is not enough for sorting, indexing and analyzing objects. Once the job is done, the segments are empty only.

  3. #3
    Join Date
    Feb 2001
    Posts
    83
    U can use DBA_EXTENTS to see how many extents allocated in that tablespace or DBA_FREE_SPACE to check what r the free extents in that tablespace.
    with regards
    Prasanna S

  4. #4
    Join Date
    Jun 2000
    Location
    Toronto, ON, Canada
    Posts
    50
    V$SORT_SEGMENT - info about the current size of temp tablespaces
    V$SORT_USAGE- sorts that are happening currently in the DB

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