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

Thread: rbs

  1. 07-11-2001, 07:40 AM #1
    helpme
    helpme is offline Senior Member
    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?
    Reply With Quote Reply With Quote
  2. 07-11-2001, 08:35 AM #2
    jmodic
    jmodic is offline Super Moderator
    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?
    Reply With Quote Reply With Quote
  3. 07-11-2001, 09:02 AM #3
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    Those typo's are a killer huh? LOL
    MH
    Reply With Quote Reply With Quote
  4. 07-11-2001, 09:37 AM #4
    jmodic
    jmodic is offline Super Moderator
    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?
    Reply With Quote Reply With Quote
  5. 07-11-2001, 11:01 AM #5
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134

    Talking

    It's always refreshing to see some innocent good humor in these forums
    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