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: object # of extents

Re: object # of extents

From: gazzag <gareth_at_jamms.org>
Date: 28 Jun 2006 09:25:24 -0700
Message-ID: <1151511924.666907.65070@p79g2000cwp.googlegroups.com>


Ben wrote:
> > Frank van Bortel wrote:
> > > Ben schreef:
> > > > Running Oracle 9.2.0.5 Ent Ed, DMTs, UNIX AIX5L, compatible parameter =
> > > > 8.1.0
> > > >
> > > On 9i, release 2, you should really get used to locally managed
> > > tablespaces with auto segment space management.
> > > In that case, you will probably never even *have* 1500 extents!
> > >
> > > And I start worrying at about 4000 (four thousand) extents. And
> > > even then, I doubt it would be "a concern".
> > >
> > > --
> > > Regards,
> > > Frank van Bortel
> > >
> > > Top-posting is one way to shut me up...
>
> well, how about 8000 then?

Other than a perceived excessive extent usage, what "problem" are you attempting to solve? Received on Wed Jun 28 2006 - 11:25:24 CDT

Original text of this message

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