RE: URGENT - Can you coalesce a RBS tablespace?

  • From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <jhenslee@xxxxxxxxxxxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 6 Sep 2005 13:08:45 -0400


Have you shrunk the existing rollback segments?  You may have some that
are huge in size.  You can shrink them and this will free up space in
the RBS tablespace.


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Henslee, Jeff
Sent: Tuesday, September 06, 2005 12:55 PM
To: Oracle-L Freelists
Subject: URGENT - Can you coalesce a RBS tablespace?

We seem to be having troubles with some of our RBS segments.  We are
unable to create new segments or extend existing ones.  This is an
unusual pattern and we're trying to find a way to get people back
working again without having to add a datafile to the RBS area (if at
all possible) or restart the instance.

Options please?

Thank you.

Jeffrey C. Henslee (Chico)
Six Sigma Green Belt
Wausau Window and Wall Systems
(715) 846-3196


Other related posts: