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

Thread: rbs

  1. #1
    Join Date
    Jun 2001
    Posts
    316
    I just create a new database and i c that that the rbs table space is already using 50 Mb space..

    How is it possible?

    Can i empty this table space?

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by helpme
    I just create a new database and i c that that the rbs table space is already using 50 Mb space..

    How is it possible?
    The existing rollback segments you have created at database creation take this space. Count the number of rollback segments in that tablespace, multiply this with inital extent size multiplied by MINEXTENT and you'll get 50MB.

    Can i empty this table space?
    Only by dropping some of the rollback segments..

    [Edited by jmodic on 07-11-2001 at 09:34 AM]
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    Those typo's are a killer huh? LOL
    MH

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by Mr.Hanky
    Those typo's are a killer huh? LOL
    MH
    It tooke me a while to find out what you mean. I was LOL too. Anyway, I've corrected the offending word .
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Jan 2001
    Posts
    3,131

    Talking

    It's always refreshing to see some innocent good humor in these forums

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