RE: on tablespace and extent size for RBS
- From: "NGUYEN Philippe (Cetelem)" <philippe.nguyen@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 18 Jun 2004 08:56:46 +0200
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]De
la part de Goulet, Dick
Envoyé : jeudi 17 juin 2004 18:15
À : oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx]
Sent: Thursday, June 17, 2004 11:49 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of NGUYEN Philippe (Cetelem)
Sent: Thursday, June 17, 2004 9:45 AM
To: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
