From oracle-l-bounce@freelists.org Tue Sep 6 16:23:03 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j86LN2iR004017 for ; Tue, 6 Sep 2005 16:23:02 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j86LN0IP004006 for ; Tue, 6 Sep 2005 16:23:00 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A6F031E9BD7; Tue, 6 Sep 2005 16:22:55 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23296-04; Tue, 6 Sep 2005 16:22:55 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2CFCE1E991E; Tue, 6 Sep 2005 16:22:55 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: URGENT - Can you coalesce a RBS tablespace? Date: Tue, 6 Sep 2005 16:21:00 -0500 Message-ID: <3F02DCE8969E484482022C07D8CD6D9B845C72@waumail02.wausau.int> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: URGENT - Can you coalesce a RBS tablespace? Thread-Index: AcWzJftgfLRabLTqTq+eLq1Qc3dZCQAAceoA From: "Henslee, Jeff" To: Cc: , "Oracle-L Freelists" X-OriginalArrivalTime: 06 Sep 2005 21:21:00.0719 (UTC) FILETIME=[E1237BF0:01C5B328] X-archive-position: 25080 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jhenslee@wausauwindow.com Precedence: normal Reply-To: jhenslee@wausauwindow.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.3 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 Apologies - Here's are the error messages I was receiving - ORA-01562 Failed to extend rollback segment number 11 ORA-01650 unable to extend rollback segment RBS10 by 128 in tablespace RBS. It started with one user at first and then started to spread to a number of users on the same instance. The weird thing about it was the initial extent of segment 10 was 128. The next size was 1M with the optimal size being 5M. It appeared that it was even having troubles with the initial extent. I guess that is why I labeled it 'urgent'. I wasn't sure why it couldn't even create the initial extent. The free space still does not appear to be giving itself back to the instance.... Thanks for asking for the follow-up - I want to make sure that I too, contribute to this forum. Jeff -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Jared Still Sent: Tuesday, September 06, 2005 3:59 PM To: Henslee, Jeff Cc: chiragdba@gmail.com; Oracle-L Freelists Subject: Re: URGENT - Can you coalesce a RBS tablespace? Glad to see your problems have abated somewhat. Many of us would still like to know what indications you saw (error message?) that identified rollback segments as the source of the problem. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist On 9/6/05, Henslee, Jeff wrote: > > 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. > -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l