Connor,
Reorgs to change the blocksize are reduced even
further in 9i since multiple blocksizes are allowed in
the same database, although you still can't change the
default blocksize without rebuilding.
The new free list allocation mechanism looks pretty
slick too.
Definitely lots of new goodies to play with ;)
- Anita
- Connor McDonald <hamcdc_at_yahoo.co.uk> wrote:
> There are reorgs to fix fragmentations, and reorg to
> reclaim dirty space. LMT's fix the former but not
> necessarily the latter.
>
> I do believe tho' that the days of unloading the
> entire database and reloading it (with the exception
> of changing the blocksize) should be a thing of the
> past
>
> hth
> connor
>
> --- Yosi_at_comhill.com wrote: > All,
> >
> > Oracle's party line has for a while been that for
> > the most
> > part reorgs aren't necessary anymore, right?
> > Assuming storage
> > initially has been set decently? Are reorgs very
> > common in
> > these parts?
> >
> > Also, even according to those who find reorgs
> still
> > necessary,
> > they should completely go away with LMT's, right?
> >
> > Opinions all?
> >
> > Thanks,
> >
> > Yosi Greenfield
> > Oracle DBA, Will work for food
> > ygreenfield_at_compuserve.com
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author:
> > INET: Yosi_at_comhill.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).
>
>
> =====
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at
> http://www.oradba.freeserve.co.uk)
>
> "Some days you're the pigeon, some days you're the
> statue"
>
>
> Do You Yahoo!?
> Get your free @yahoo.co.uk address at
> http://mail.yahoo.co.uk
> or your free @yahoo.ie address at
> http://mail.yahoo.ie
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Connor=20McDonald?=
> INET: hamcdc_at_yahoo.co.uk
>
> 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!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_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 Sat Jun 16 2001 - 07:51:49 CDT