From oracle-l-bounce@freelists.org Tue Sep 6 12:32:06 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j86HW61N006783 for ; Tue, 6 Sep 2005 12:32:06 -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 j86HW1IP006769 for ; Tue, 6 Sep 2005 12:32:02 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C84A91E9779; Tue, 6 Sep 2005 12:31:57 -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 32767-02; Tue, 6 Sep 2005 12:31:57 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 441ED1E9776; Tue, 6 Sep 2005 12:31:57 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5B308.9E810E90" Subject: RE: URGENT - Can you coalesce a RBS tablespace? Date: Tue, 6 Sep 2005 13:30:05 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: URGENT - Can you coalesce a RBS tablespace? thread-index: AcWzBrR3UFrGS+P0TjGchorGJroyYwAAblAg From: "Mercadante, Thomas F (LABOR)" To: "Chirag DBA" Cc: , "Oracle-L Freelists" X-OriginalArrivalTime: 06 Sep 2005 17:30:05.0802 (UTC) FILETIME=[9EF6ECA0:01C5B308] X-archive-position: 25061 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Thomas.Mercadante@labor.state.ny.us Precedence: normal Reply-To: Thomas.Mercadante@labor.state.ny.us 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.2 required=5.0 tests=AWL,BAYES_00,HTML_50_60, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5B308.9E810E90 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Optimum doesn't work too well in 8.1.7.4 (like not at all) =20 Shrinking them by hand is certainly not the long-term answer. Re-writing the offending sql is the long-term answer. =20 ________________________________ From: Chirag DBA [mailto:chiragdba@gmail.com]=20 Sent: Tuesday, September 06, 2005 1:16 PM To: Mercadante, Thomas F (LABOR) Cc: jhenslee@wausauwindow.com; Oracle-L Freelists Subject: Re: URGENT - Can you coalesce a RBS tablespace? =20 Try setting the OPTIMUM parameter, which will reduce the size of yr segment after finishing the transaction. That can help you to get through. =20 But if the transactions are long, they can generate 1555 erros in yr trace files. =20 Look for this too. =20 Regards - Chirag=20 =20 On 9/6/05, Mercadante, Thomas F (LABOR) wrote:=20 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=20 the RBS tablespace. Tom -----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? We seem to be having troubles with some of our RBS segments. We are=20 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? Thank you. 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=20 =20 ------_=_NextPart_001_01C5B308.9E810E90 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Optimum doesn’t work too well = in 8.1.7.4 (like not at all)

 

Shrinking them by hand is certainly = not the long-term answer.  Re-writing the offending sql is the = long-term answer.

 


From: = Chirag DBA [mailto:chiragdba@gmail.com]
Sent: Tuesday, September = 06, 2005 1:16 PM
To: Mercadante, Thomas F = (LABOR)
Cc: = jhenslee@wausauwindow.com; Oracle-L Freelists
Subject: Re: URGENT - Can = you coalesce a RBS tablespace?

 

Try setting the OPTIMUM parameter, which will reduce the size of = yr segment 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 files.

 

Look for this too.

 

Regards - Chirag

 

On 9/6/05, Mercadante, Thomas F (LABOR) <Thomas.Mercadante@lab= or.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-----
From: oracle-l-bounce@freelists.o= rg
[mailto:oracle-l-bounce@freelists.o= rg ] 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@wausauwindow.com =

--
http://www.freelists.o= rg/webpage/oracle-l
--
http://www.freelists.o= rg/webpage/oracle-l

 

------_=_NextPart_001_01C5B308.9E810E90-- -- http://www.freelists.org/webpage/oracle-l