Database Administration (MOSC)

MOSC Banner

HWM and check, if object is fragmented

Hello,

I found an object in production that was fragmented.

I would now like to automatically detect whether the object is a candidate for defragmentation.

Some documents in MOS and here too provide information about HWM and fragmentation.

What HWM and fragmentation is is known, but as mentioned, how can I recognize it?

Is function dbms_space.verify_shrink_candidate a easy way ?  Nothing could be found in official oracle documents, except for a good description on this homepage https://www.morganslibrary.org/reference/pkgs/dbms_space.html

I install the procedure show_space from the well-known oracle guru Tom Kyte based on instructions on the

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center