SGA(DEALLOCATE TEMP SEGMENTS)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SGA(DEALLOCATE TEMP SEGMENTS)

  1. #1
    Join Date
    Sep 2000
    Posts
    305
    SMON DEALLOCATE THE TEMP SEGMENTS IS IT CORRECT/

    BEFORE SHUTDOWN ORACLE SERVER THE TEMP SEGMENT IS USING 29% OF ITS AVAILIABLE SPACE BUT WHEN I SHUTDOWN ORACLE SERVER IT IS STILL SHOWING 29% IT SHOULD DEALLOCATE THE SPACE .

    PLEASE ADVICE ME

    SHAILENDRA

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    hmm I wonder how can you know 29% is used if the instance is shutdown

  3. #3
    Join Date
    Sep 2000
    Posts
    305
    SORRY IT WAS MY MISTAKE IN TYPING WHEN I START IT AGAIN THEN IT WAS SHOWING THE SAME USAGE.

    SHAILENDRA

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