Re: ROLLBACK SEGMENT FRAGMENTATION

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Mon, 07 Oct 2002 09:24:03 -0800
Message-ID: <F001.004E26FA.20021007092403@fatcity.com>

before you do all this.... by fragmented do you mean that there are a large number of free extents in the tablespace?

If so, are those extents all the same size or at least a multiple of the same size?

If so, why are you bothering to defragment?

You would only need to defragment the rollback tablespace if you have rollback segments where the initial and next extent sizes are not multiples of each other and/or where each rollback segment has a differently sized initial and next extents that are not multiples of the extent sizes of the other rollback segments...

otherwise you are not "fragmented", you just have a lot of free extents that are the right size for Oracle to use. this is NOT a bad thing

• Seema Singh <oracledbam_at_hotmail.com> wrote:
  > Hi
  > My rollback tablespace is highly fragmented.I am thinking to do like
  > following?
  > -Create new rollback tablespace rbs1
  > -Create rollback segments
  > -Offline all rollback segments from old rollback tablespace (rbs)
  > -Drop rollback segments from rbs tablespace
  > -Drop tablespace rbs
  > -Create RBS tablespace
  > -Create rollback segments on RBS tablespace
  > -Drop tablespace RBS1
  > Is this way is good to manage?
  > Let me know if anythings are missing please?
  > Thx
  > -Seema
  >
  >
  >
  > _________________________________________________________________
  > MSN Photos is the easiest way to share and print your photos:
  > http://photos.msn.com/support/worldwide.aspx
  >
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.com
  > --
  > Author: Seema Singh
  > INET: oracledbam_at_hotmail.com
  >
  > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
  > San Diego, California -- Mailing list and web hosting services
  > ---------------------------------------------------------------------
  > To REMOVE yourself from this mailing list, send an E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB ORACLE-L
  > (or the name of mailing list you want to be removed from). You may
  > also send the HELP command for other information (like subscribing).
  

  ---

Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Oct 07 2002 - 12:24:03 CDT