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

Thread: problem in temp tablespace

  1. #1
    Join Date
    Apr 2004
    Location
    israel
    Posts
    2

    problem in temp tablespace

    i have a problem with a oracle 8i 8.1.7
    my temp tablespace grow and dont stop to grow untill i shutdown the database and start it again.
    after i restart the database the temp is empty
    how can i check what is the problem???
    the temp dont clean even the session is closed.

    regrads,
    eli

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Are you looking at the TEMP through OEM/TOAD, if so this is normal behaviour. The segments are not automatically deallocated unless you shutdown.
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Jan 2003
    Location
    Delhi
    Posts
    63
    Are u telling that toad/oem gives different result comparing to sqlplus>

  4. #4
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Originally posted by mdash
    Are u telling that toad/oem gives different result comparing to sqlplus>
    Maybe u can play with this script:
    SELECT tablespace_name, extent_size, total_extents, used_extents, free_extents, max_used_size
    FROM v$sort_segment;

    or this :
    SELECT s.username, u.tablespace, u.contents, u.extents,u.blocks FROM v$session s, v$sort_usage u
    WHERE s.saddr=u.session_addr;
    ---------------

  5. #5
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Originally posted by mdash
    Are u telling that toad/oem gives different result comparing to sqlplus>
    OEM will show you the extents allocated in the tablespace, once these extents have been allocated they are reused by other sessions. OEM cannot always provide an acurate picture of the segments in use.
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: problem in temp tablespace

    Originally posted by elibz
    i have a problem with a oracle 8i 8.1.7
    my temp tablespace grow and dont stop to grow untill i shutdown the database and start it again.
    after i restart the database the temp is empty
    how can i check what is the problem???
    the temp dont clean even the session is closed.

    regrads,
    eli
    set a max size for the file
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  7. #7
    Join Date
    Aug 2002
    Posts
    10
    set max file size maybe cause the system hanging

  8. #8
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by wengyan
    set max file size maybe cause the system hanging
    What are u talking about?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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