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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Extent allocation

RE: Extent allocation

From: Shakeel Qureshi <msklq_at_yahoo.com>
Date: Fri, 09 Feb 2001 14:36:32 -0800
Message-ID: <F001.002B0D99.20010209141030@fatcity.com>

Hi Patrick,
No. Its not locally managed tablespace.

Shakeel Qureshi
squreshi_at_barpoint.com
--- Tim Sawmiller <sawmillert_at_state.mi.us> wrote:
> Somewhere in the depths of Oracle 8.1 documentation,
> you will find a description of the extent algorithm.
> It's supposed to be more "enlightened" in
> allocating blocks to extents, in that it will try to
> allocate just what you asked for, and also try to
> fill holes, so it no longer necessarily rounds up to
> the nearest 5 blocks anymore.
>
> >>> Patrick.Elliott_at_bestbuy.com 02/08/01 03:26PM >>>
> Is the tablespace you are creating this table in a
> Locally Managed
> Tablespace? If so, then initial and next extents
> will be ignored.
>
> > -----Original Message-----
> > From: Shakeel Qureshi [SMTP:msklq_at_yahoo.com]
> > Sent: Thursday, February 08, 2001 1:35 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Extent allocation
> >
> > Hi Paul,
> >
> > I created an object with initial_extent 128K and
> it
> > took 13 blocks. I then created the same object
> with
> > 208K and still it took 13 blocks. My db_block
> size is
> > 16K. I tested this on 8.1.5 and 8.1.6 and they
> both
> > behave the same.
> >
> >
> > TIA,
> >
> > Shakeel Qureshi
> > squrehi_at_barpoint.com
> > --- Paul Baumgartel <PaulB_at_instipro.com> wrote:
> > > It is a big clue. Oracle rounds to multiples of
> 5
> > > extents to prevent the
> > > existence of a free extent of fewer than 5
> blocks,
> > > which is unlikely to be
> > > usable.
> > >
> > >
> > >
> > > Paul Baumgartel
> > > InstiPro, Inc.
> > > paul.baumgartel_at_instipro.com
> > > 212 813-0829 x103 (office)
> > > 917 549-4717 (mobile)
> > >
> > > -----Original Message-----
> > > Sent: Wednesday, February 07, 2001 4:26 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >
> > > Hi -
> > >
> > > I am confused now about how oracle actually
> > > determines the size an extent
> > > should be. I have db_block_size set at 8192 and
> > > have defined a tablespace
> > > (and tables) at initial and next extents of
> 128K.
> > > When I do a show
> > > parameter db_file_multiblock_read_count it says
> 8.
> > > Therefore I thought 128K
> > > would be a good number, since it is a multiple
> of
> > > these numbers.
> > >
> > > However, when I check my extent sizes, I see
> that
> > > each extent contains 10
> > > blocks which is 160K.
> > >
> > > I remember reading an article some time ago
> about
> > > how oracle actually
> > > determines what it thinks the extent size should
> be.
> > > Does anyone know of an
> > > article like this, or can anyone explain to me
> why
> > > it chose a different
> > > extent size?
> > >
> > > By the way, I looked at several tables and the
> one
> > > common thing I noticed is
> > > that the number of blocks allocated seems to be
> a
> > > multiple of 5 - ie. some
> > > are 5 blocks, some 10, some 20, etc. I don't
> know
> > > if that's coincidence or
> > > a big clue to the whole thing
> > >
> > > Lisa
> > >
> > >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get personalized email addresses from Yahoo! Mail
> - only $35
> > a year! http://personal.mail.yahoo.com/
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Shakeel Qureshi
> > INET: msklq_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing Lists
> >

>



> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from). You may
> > also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Elliott, Patrick
> INET: Patrick.Elliott_at_bestbuy.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists

>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Tim Sawmiller
> INET: sawmillert_at_state.mi.us
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists

>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).


Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shakeel Qureshi
  INET: msklq_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Feb 09 2001 - 16:36:32 CST

Original text of this message

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