RE: URGENT - Can you coalesce a RBS tablespace?
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>, "Chirag DBA" <chiragdba@xxxxxxxxx>
- Date: Tue, 6 Sep 2005 13:35:57 -0400
Correction, Optimal does work in 8.1.7.4, I'm using it successfully,
although there are limits. First off you HAVE to have a minimum of 2
extents and the optimal should be set to the sum of the initial and next
extents in even blocks.
_____
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mercadante, Thomas F
(LABOR)
Sent: Tuesday, September 06, 2005 1:30 PM
To: Chirag DBA
Cc: jhenslee@xxxxxxxxxxxxxxxx; Oracle-L Freelists
Subject: RE: URGENT - Can you coalesce a RBS tablespace?
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@xxxxxxxxx]
Sent: Tuesday, September 06, 2005 1:16 PM
To: Mercadante, Thomas F (LABOR)
Cc: jhenslee@xxxxxxxxxxxxxxxx; 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@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx ] 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@xxxxxxxxxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
