RE: on tablespace and extent size for RBS

From: NGUYEN Philippe (Cetelem) <philippe.nguyen_at_cetelem.fr>
Date: Fri, 18 Jun 2004 08:56:46 +0200
Message-ID: <DCEE3C62548AFE48ADF88CBFDB8260A205089244@NGMAIL3>

sorry for the lack of informations, my question is based on a 8i instance. I use different uniform-size extents for my LMT depend on the size of the tables but, for rollback segment, do you also use different sizes as we never know (unless making SET TRANSACTION USE RBS....) which rollback and which king of tables we be in use ?

-----Message d'origine-----

De : oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]De la part de Goulet, Dick
Envoyé : jeudi 17 juin 2004 18:15
À : oracle-l_at_freelists.org
Objet : RE: on tablespace and extent size for RBS

That would depend on the version of Oracle. Not everyone is running 9i or better.

Philippe,

I use Locally managed, uniform extents. Extent size depends on the database and it's usage. One has 16K extents in a 1M tablespace where as another has 10M in a 4GB tablespace.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

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

From: Justin Cave [mailto:justin_at_askddbc.com] Sent: Thursday, June 17, 2004 11:49 AM
To: oracle-l_at_freelists.org
Subject: RE: on tablespace and extent size for RBS

Can you use an UNDO tablespace instead of rollback segments?

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com <http://www.ddbcinc.com/askDDBC> /askDDBC

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of NGUYEN Philippe (Cetelem)
Sent: Thursday, June 17, 2004 9:45 AM
To: oracle-l_at_freelists.org
Subject: on tablespace and extent size for RBS

Hi List!
just a little advice on tbs for Rollback Segment : do you use DMT, LMT, with uniform and extent size ? TIA
Philippe

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Fri Jun 18 2004 - 01:53:27 CDT