Re: performance profit after reorganisation

Hi,

yes, you've right, but im looking for a statistic about +/- CPU Utlilation for I/O Utlilation.

Thanks
joe

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> schrieb im Newsbeitrag news:23inut8fs2aikha5ors24m6jehjesuk8bs_at_4ax.com...
> On Fri, 9 Nov 2001 11:13:47 +0100, "Joachim Misselbeck"
> <joachim.misselbeck_at_gmx.net> wrote:
>
> >Hi to all,
> >
> >have any body experince about table/tablespace reorg and the profit (
I/O,
> >CPU Util., etc. ) ? Or a link to more information about this ?
> >
> >
> >Thanks for all answers
> >
> >Joe
> >
> >p.s.
> >I know the orginal Statment of Oracle ( You don't need this at any time ,
> >but it's not really true )
> >
> >
> >
> Main advantages of reorganisation are:
> - no row chaining any more
> - all free space coalesced at the end of the tablespace (doesn't apply
> when using locally managed tablespaces), so option to resize the
> tablespace.
> - optimally organized indexes, which might even result in indexes with
> one B-tree level less.
>
> Hth
>
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Sun Nov 11 2001 - 09:30:29 CET