Re: dbms_space.space_usage and effectiveness of purge operations

From: Martin Klier <usn_at_usn-it.de>
Date: Tue, 05 Nov 2013 21:00:27 +0100
Message-ID: <52794E5B.20809_at_usn-it.de>

Sorry if I'm obfuscating the intentions of th OP, but maybe some basic thoughts about the motivation to coalesc indexes are to be asked for.

Why would we want to coalesce indexes anyway? Ok, after deleting huge amounts of data that will never come back, to save space and maybe reduce the index blevel.

But for a "breathing" or steadily growing dataset, why bother?

It might be a heretical question, but it would be nice to hear opinions. :)

Thanks a lot
Martin

Am 05.11.2013 20:23, schrieb Mark W. Farnham:

> I do repeat my question about what his goal is. Densely packed leaf
> blocks not being a good thing for OLTP near random index insertion, I
> **hope** densely packing leaf blocks is not his goal.--

-- 
Usn's IT Blog for Oracle and Linux
http://www.usn-it.de

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 05 2013 - 21:00:27 CET