RE: URGENT - Can you coalesce a RBS tablespace?

I think things have slowed down a little bit. I am over the hump by trying a number of suggestions from a number of you (and I thank you all).  

I have tried to shrink a number of the roll back segments - although I'm not sure I was 100% successful - the segment size in OEM did not change much at all. If I add the segments that were unusually large, basically, they consume almost the entire datafile (1GB) -  

I did try to kill a couple of older user connections that were very old and stale.  

I am also working with the developer and making sure that his code makes better use of commits at the proper time (and more often). I think that this is my best recourse. After discussions with a couple of users, they appeared to be processing a rather large set of data in a big chunk (rather than in smaller chunks). This processing is not "normally" how it occurs (in big chunks that is) and therefore was not planed for when the DB was originally created.  

I did (against my original statement) add a small number of blocks to the data file (200M) in order to get me over the hump. I am still trying to chase down the "real" issue.  

Thank you all so much for your suggestions and feedback.  

I really appreciate all of the help I get from this list.  

Thank you.

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

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Chirag DBA Sent: Tuesday, September 06, 2005 1:14 PM To: Henslee, Jeff
Cc: Oracle-L Freelists
Subject: Re: URGENT - Can you coalesce a RBS tablespace?

so jeff  

... does all this discussion has resolved yr problem?  

U said it was URGENT and of course bouncing the DB is not a long term answer.  

Let us know if you r getting any error in trace files.  

Regards - Chirag  

On 9/6/05, Henslee, Jeff < jhenslee_at_wausauwindow.com> wrote:

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 <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 - 13:42:42 CDT