RE: URGENT - Can you coalesce a RBS tablespace?

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Tue, 6 Sep 2005 13:03:25 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA6502C8B587@25exch1.vicorpower.vicr.com>

Look through the V$SESSIONS table for anyone who have been sitting around for a long time doing nothing. They could dbe holding up the rollback/undo.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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
mailto:jhenslee_at_wausauwindow.com

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 06 2005 - 12:05:25 CDT