it's definitely friday :)
- Jack Silvey <jack_silvey_at_yahoo.com> wrote:
> Lose 20 blocks in 10 days! Load as much as you
> normally do and still lose index width.
>
> no segment size restrictions or tiring delete routines
> that never seem to finish. easy-to-follow
> substr(column,1,1) update routine that guarentees a
> maximum of data loss and a minimum of storage!
>
> email to fastindexweightloss_at_skinnydata.com for
> details.
>
>
>
>
> --- Rachel Carmichael <wisernet100_at_yahoo.com> wrote:
> > I'm sure it's #6 :)
> >
> >
> > --- Jack Silvey <jack_silvey_at_yahoo.com> wrote:
> > > Matt,
> > >
> > > 1) Storage parameter changes? Do you specify
> > storage
> > > at the index or tablespace (or top partition)
> > > level?pctfree go up? initrans go up? bigger
> > INITIAL or
> > > NEXT?
> > >
> > > 2) did you build it the first time using
> > parallelism
> > > and rebuild using single thread? When a PQ
> > processes
> > > is used to build an object it uses its own extent,
> > and
> > > then *deallocates the extra space* at the end. If
> > you
> > > will notice, when you build using PQ your segments
> > > have wacko sizes, and that is why.
> > >
> > > If you rebuilt using a single process, it could be
> > > that you have a full allocation of space, some
> > empty.
> > >
> > > 3) more data? did you "alter unusable", load, and
> > > rebuild?
> > >
> > > 4) have you changed the minimize_records_per_block
> > > parameter and the index is a bitmap?
> > >
> > > 5) has your data distribution changed? bitmap
> > indexes
> > > tend to get bigger as your data moves towards high
> > > cardinality.
> > >
> > > 6) has this index been eating too much sugar
> > again?
> > > sometimes, this can cause an index glucose spike
> > and
> > > tend to make it store more fat in the leaf blocks,
> > > especially around the middle of the index, but
> > > sometimes on the hips too. Perhaps you are not
> > doing
> > > DDL on the table enough, and so the index is not
> > > getting enough exercise.
> > >
> > > hth,
> > >
> > > jack silvey
> > >
> > >
> > > > --- "Adams, Matthew (GEA, MABG, 088130)"
> > > > <MATT.ADAMS_at_APPL.GE.COM>
> > > > wrote:
> > > > > Under what conditions would an 'alter index ..
> > > > rebuild'
> > > > > actually case the size of the index to
> > increase
> > > > > by about 12 percent?
> > > > >
> > > > >
> > > > >
> > > > > ----
> > > > > Matt Adams - GE Appliances -
> > > > matt.adams_at_appl.ge.com
> > > > > Contrary to popular opinion, Unix is user
> > > > friendly.
> > > > > It's just particular about who it makes
> > friends
> > > > with.
> > > > >
> > > >
> > > >
> > > >
> > __________________________________________________
> > > > Do You Yahoo!?
> > > > Yahoo! - Official partner of 2002 FIFA World Cup
> > > > http://fifaworldcup.yahoo.com
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> > > > http://www.orafaq.com
> > > > --
> > > > Author: Rachel Carmichael
> > > > INET: wisernet100_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).
> > >
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Yahoo! - Official partner of 2002 FIFA World Cup
> > > http://fifaworldcup.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > --
> > > Author: Jack Silvey
> > > INET: jack_silvey_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).
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! - Official partner of 2002 FIFA World Cup
> > http://fifaworldcup.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> > INET: wisernet100_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).
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jack Silvey
> INET: jack_silvey_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
>
=== message truncated ===
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_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 May 31 2002 - 14:03:50 CDT
