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