From oracle-l-bounce@freelists.org Tue Sep 6 12:18:21 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j86HILOu005295 for ; Tue, 6 Sep 2005 12:18:21 -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 j86HIIIP005284 for ; Tue, 6 Sep 2005 12:18:18 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0BD0E1E8FBD; Tue, 6 Sep 2005 12:18:14 -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 27681-04; Tue, 6 Sep 2005 12:18:13 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7CD761E7FAD; Tue, 6 Sep 2005 12:18:13 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=d2aHyALPehdDkgz4ZvMRqlKlRYxIhlaWeeu1JuCQ4dOVgJ0eRwCJjWbOITcb/BWkPG4UmMm5ic/cfua9E9C8qujSF0Fn3oKxaiJCRdfJ3QUEZtjWPagoaBiICUYOeOCQtaaNPezPnYbtlI4DkriEq+I7mV1zRHBX7wFwNS9fwQg= Message-ID: <1a362960050906101683d3137@mail.gmail.com> Date: Tue, 6 Sep 2005 13:16:21 -0400 From: Chirag DBA To: Thomas.Mercadante@labor.state.ny.us Subject: Re: URGENT - Can you coalesce a RBS tablespace? Cc: jhenslee@wausauwindow.com, Oracle-L Freelists In-Reply-To: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_39281_13196985.1126026981780" References: X-archive-position: 25060 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: chiragdba@gmail.com Precedence: normal Reply-To: chiragdba@gmail.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=-3.3 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_39281_13196985.1126026981780 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Try setting the OPTIMUM parameter, which will reduce the size of yr segment= =20 after finishing the transaction. That can help you to get through. But if the transactions are long, they can generate 1555 erros in yr trace= =20 files. Look for this too. Regards - Chirag=20 On 9/6/05, Mercadante, Thomas F (LABOR) < Thomas.Mercadante@labor.state.ny.us> wrote:=20 >=20 > Jeff, >=20 > 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. >=20 > Tom >=20 > -----Original Message----- > From: oracle-l-bounce@freelists.org > [mailto:oracle-l-bounce@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? >=20 > 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. >=20 > Options please? >=20 > Thank you. >=20 > Jeffrey C. Henslee (Chico) > Six Sigma Green Belt > Wausau Window and Wall Systems > (715) 846-3196 > mailto:jhenslee@wausauwindow.com >=20 > -- > http://www.freelists.org/webpage/oracle-l > -- > http://www.freelists.org/webpage/oracle-l > ------=_Part_39281_13196985.1126026981780 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Try setting the OPTIMUM parameter, which will reduce the size of yr se= gment after finishing the transaction. That can help you to get through.
 
But if the transactions are long, they can generate 1555 erros in yr t= race files.
 
Look for this too.
 
Regards - Chirag

 
On 9/6/05, M= ercadante, Thomas F (LABOR) <Thomas.Mercadante@labor.state.ny.us> wrote:
Jeff,

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.

Tom

-----Original Message-----
Fro= m: oracle-l-bounce@freelis= ts.org
[mailto:orac= le-l-bounce@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 t= ablespace?

We seem to be having troubles with some of our RBS segmen= ts.  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<= br>working again without having to add a datafile to the RBS area (if atall possible) or restart the instance.

Options please?

Thank you.

Jeffrey C. Henslee (Chico)=
Six Sigma Green Belt
Wausau Window and Wall Systems
(715) 846-319= 6
mailto:jhenslee@wausauwin= dow.com

--
htt= p://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

------=_Part_39281_13196985.1126026981780-- -- http://www.freelists.org/webpage/oracle-l