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

Thread: SGA(DEALLOCATE TEMP SEGMENTS)

  1. 09-01-2002, 05:28 AM #1
    shailendra
    shailendra is offline Senior Member
    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
    Reply With Quote Reply With Quote
  2. 09-01-2002, 05:54 AM #2
    pando
    pando is offline Pando & Company
    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
    Reply With Quote Reply With Quote
  3. 09-01-2002, 06:31 AM #3
    shailendra
    shailendra is offline Senior Member
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width