RE: on tablespace and extent size for RBS

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Thu, 17 Jun 2004 12:14:52 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA650146C3E3@25exch1.vicorpower.vicr.com>

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 Thu Jun 17 2004 - 11:11:55 CDT