According to the Oracle documentation, it's the OS
block size.
- VIVEK_SHARMA <VIVEK_SHARMA_at_infy.com> a écrit : >
> Thanks indeed for the Article's Excerpt , Paul
>
> Our db_block_size=8K
>
>
> > -----Original Message-----
> > From: Paul Drake [SMTP:paled_at_home.com]
> > Sent: Thursday, June 28, 2001 1:46 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Fragmentation & Locally Managed
> Tablespaces
> >
> > VIVEK_SHARMA wrote:
> > >
> > > Is Fragmentation of Objects meaningless in
> Locally managed
> > Tablespaces
> > > Assuming EXTENTS is 3,000 for Some of the
> Objects
> > >
> > > Or Do the Objects need to be DE-Fragmented using
> exp/imp ?
> > >
> >
> > Vivek,
> >
> > funny, I was just looking into this tonight.
> >
> > what is your block size?
> >
> > I would recommend a quick visit to our friend
> Steve Adams site:
> >
> > http://www.ixora.com.au/tips/creation/extents.htm
> >
> > "For this reason, we recommend that the number of
> extents per segment
> > in
> > locally managed tablespaces be limited to the
> number of rows that can
> > be
> > accommodated in the extent map within the segment
> header block
> > - that is, approximately (db_block_size / 16) -
> 7."
> >
> > for an 8 KB block size - that is 505 extents per
> segment.
> >
> > Those objects would be good candidates to move to
> a different (new?)
> > tablespace with a larger (uniform) extent size.
> >
> > Paul
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Paul Drake
> > INET: paled_at_home.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: VIVEK_SHARMA
> INET: VIVEK_SHARMA_at_infy.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).
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com
Do You Yahoo!? -- Pour faire vos courses sur le Net,
Yahoo! Shopping :
http://fr.shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
INET: stephane_paquette_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 Thu Jun 28 2001 - 07:01:14 CDT
