Re: Episode 2: the EntMgr Green Light!!

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 8 Nov 2003 14:05:33 +1100
Message-ID: <3fac5d87$0$15336$afc38c87@news.optusnet.com.au>

Not to rub the point in, but...

"Domenic G." <domenicg_at_hotmail.com> wrote in message news:c7e08a19.0311071534.24e0a280_at_posting.google.com... [sbip]
> like i said, i don't rebuild all of them -- looks like you're
> abandoning your databases.
> >
> > Have you considered coalescing ?
>
> no i use local extent management

Remember what you were saying about "qualified professionals" and "experienced DBAs who know what they're doing" versus "trained monkeys"?

A qualified DBA who knows what he's doing would know the difference between

alter tablespace X coalesce;

and

alter index xxx coalesce.

The fact that Richard mentions coalescing of indexes (to improve leaf-node usage rates) and you reply by talking about Locally Managed Tablespaces (which certainly don't need coalescing to cure fragmentation) means you don't know or realise there's a difference.

The conclusion to be drawn...?

I guess you can work it out.

HJR Received on Fri Nov 07 2003 - 21:05:33 CST