Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!ihug.co.nz!newsfeed00.sul.t-online.de!newsmm00.sul.t-online.com!t-online.de!news.t-online.com!not-for-mail
From: "Joachim Misselbeck" <joachim.misselbeck@mplusw.com>
Newsgroups: comp.databases.oracle.tools
Subject: Re: performance profit after reorganisation
Date: Sun, 11 Nov 2001 09:30:29 +0100
Organization: T-Online
Lines: 47
Message-ID: <9slck3$m56$07$1@news.t-online.com>
References: <9sgae0$rql$01$1@news.t-online.com> <23inut8fs2aikha5ors24m6jehjesuk8bs@4ax.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: news.t-online.com 1005467075 07 22694 3qOJTmiVSPYwGN 011111 08:24:35
X-Complaints-To: abuse@t-online.com
X-Sender: 07139452040-0001@t-dialin.net
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Xref: easynews comp.databases.oracle.tools:46175
X-Received-Date: Sun, 11 Nov 2001 04:39:20 MST (news.easynews.com)

Hi,

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

Thanks
joe

"Sybrand Bakker" <postbus@sybrandb.demon.nl> schrieb im Newsbeitrag
news:23inut8fs2aikha5ors24m6jehjesuk8bs@4ax.com...
> On Fri, 9 Nov 2001 11:13:47 +0100, "Joachim Misselbeck"
> <joachim.misselbeck@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