Forum Stats

  • 3,853,084 Users
  • 2,264,178 Discussions
  • 7,905,240 Comments

Discussions

Tablespace fragmentation

User_8E9DZ
User_8E9DZ Member Posts: 238 Blue Ribbon
edited Dec 17, 2014 6:20AM in Database Ideas - Ideas

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

/

User_8E9DZUser259623 -Oracle
2 votes

Active · Last Updated