Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2010
    Posts
    81

    Unanswered: TEMP tablespace in minus figure

    Hello,

    My tablespaces looks like this:-

    Tablespace (Mb) (Mb) (Mb) Used % Free %
    -------------------- ------------- ------------- ------------- -------- --------

    SYSAUX 50,080.00 2,862.06 47,216.38 94.28% 5.71%
    SYSTEM 7,096.00 4,131.44 2,963.50 41.76% 58.22%
    TEMP 36,096.00 -252,696.00 32,088.00 88.9% -700.07%

    And I have never seen the TEMP tablespace displaying a minus (-) figure.
    What does this indicate? It states that it has used 88.9% and has -700.07% free.
    I added another tempfile in the hope that it would reduce this figure,
    but nothing has changed. Do I simply wait for smon to clean up the process?
    Or the user to complete their work? Any help or resolution to this would be
    most appreciated

    Thanks in advance

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I will guess 32-bit Oracle & TEMP is larger than 2GB.

    Am I correct on both?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2010
    Posts
    81
    Yes on both counts

    Added additional temp datafile of 4gb - total size of TEMP tbs is now 36GB

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Quote Originally Posted by newdbaxchange View Post
    Yes on both counts
    In a 32-bit architect 2GB is largest positive signed integer.
    When value is greater than 2GB it is reported as a negative number.
    Live with it or upgrade to 64-bit OS & Application
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2010
    Posts
    81
    Thanks for the explanation

    Much helpful

Posting Permissions

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