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: Maxextents unlimited on LMT ?

Re: Maxextents unlimited on LMT ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 10 Jul 2002 08:30:40 +0100
Message-ID: <1026287386.13426.0.nnrp-10.9e984b29@news.demon.co.uk>

For example:

    maxextents = 18
in an autoallocate tablespace could get
you 18 extents of 64K (although not in
a nice clean tablespace) but generally
will get you ca. 2.2MB

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
        UK            July / Sept
        Australia      July / August
        Malaysia        September
        USA (MI)        November
http://www.jlcomp.demon.co.uk/seminar.html

Pete Sharman wrote in message ...

>In article <dd5cc559.0207091802.541898a0_at_posting.google.com>,
>
>I don't think it was. It was removed as part of a manageability exercise.
>Again, you might argue it shouldn't be so, but to me MAXEXTENTS is the
wrong
>thing to do capacity management with anyway.
>
Received on Wed Jul 10 2002 - 02:30:40 CDT

Original text of this message

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