Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Local managed tablespaces

Re: Local managed tablespaces

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 21 Dec 2000 18:54:01 +0800
Message-ID: <3A41E149.68A6@yahoo.com>

Mike Krolewski wrote:
>
> In article <91ospf$qk5$1_at_nnrp1.deja.com>,
> nixond_at_my-deja.com wrote:
> > I would agree that for most cases, other than system and very small
> > databases, I use uniform.
> >
> > A note I would like to add is there is a white paper on Metalink that
 I
> > think is a must read regarding locally managed tablespaces. It is
> > paper #711 and the title is "How to Stop Deframenting and Start
 Living:
> > The definitive Word of Fragmentation". It was written by two Oracle
> > guys on one of the internals teams.
> >
> > -Dan Nixon, DBA
> >
>
> Where is Metalink?
> > In article <3A3F54F3.1113_at_yahoo.com>,
> > connor_mcdonald_at_yahoo.com wrote:
> > > Frank Black wrote:
> > > >
> > > > All,
> > > >
> > > > does anyone have experience with Local Managed Tablespaces. If
 yes,
 did you
> > > > use the uniform or autoallocate
> > > > option? What are the reasons to choose for Autoallocate or the
 Uniform
> > > > option? Why use Uniform when Oracle
> > > > can handle the exent allocation by itself?
> > > >
> > > > thank in advance,
> > > >
> > > > Hink Wiersema
> > >
> > > I prefer uniform size because
> > > a) you can choose your own size
> > > b) fragmentation is zero
> > >
> > > I can't think of a reason why every tablespace (except system)
 should
> > > not be locally managed for any new database.
> > >
> > > HTH
> > > --
> > > ===========================================
> > > Connor McDonald
> > > http://www.oracledba.co.uk (mirrored at
> > > http://www.oradba.freeserve.co.uk)
> > >
> > > "Some days you're the pigeon, some days you're the statue"
> > >
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
> --
> Michael Krolewski
> Rosetta Inpharmatics
> mkrolewski_at_rii.com
> Usual disclaimers
>
> Sent via Deja.com
> http://www.deja.com/

metalink.oracle.com

You'll need an account which means you need to be paying a support license...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"
Received on Thu Dec 21 2000 - 04:54:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US