Tablespace fragmentation

User_8E9DZ

SELECT   dfsc.tablespace_name tablespace_name,

         DECODE (

            dfsc.percent_extents_coalesced,

            100,

            (DECODE (

                GREATEST ((SELECT COUNT (1)

                             FROM dba_free_space dfs

                1,

                'No Frag',

                'Bubble Frag'

             )

            ),

            'Possible Honey Comb Frag'

         )

               fragmentation_status

    FROM dba_free_space_coalesced dfsc

ORDER BY dfsc.tablespace_name

/