Re: Monitoring fragmentation

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 27 Sep 1999 08:27:03 +0100
Message-ID: <938417858.26333.0.nnrp-13.9e984b29@news.demon.co.uk>

Check out my web-site for an example
of using the dbms_space package to
do this. The package allows you to
find the high-water mark very cheaply,
and run down the free list chain to see how many blocks are on it.

The run on the free list can be quite expensive (if there are lots of blocks on it), but the package allows you to limit the number of blocks accessed.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Emmanuel Okanla wrote in message <7sm89m$mq7$1_at_news7.svr.pol.co.uk>...
>I need to monitor the presence of empty blocks due to deletes and updates,
>with a view to determining those that will benefit from a reorg. If
>possible, I would like to write a script to go through this process
>automatically, perhaps two evenings a week. Can anyone help? I suspect
>that this must have been done before, many times. Most of the Oracle
>databases of interest are v7.3, running in different Unix boxes. Any
>pointers will be appreciated.
Received on Mon Sep 27 1999 - 02:27:03 CDT