Measure the fragmentation of free space in all of the tablespaces in a database : Table space « Table « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Table
  3. Table space

Measure the fragmentation of free space in all of the tablespaces in a database

  

SQL> select
  2        Tablespace_Name,
  3        SQRT(MAX(Blocks)/SUM(Blocks))*
  4        (100/SQRT(SQRT(COUNT(Blocks)))) Fsfi
  5  from DBA_FREE_SPACE
  6  group by
  7        Tablespace_Name
  8  order by 1
  9
SQL> spool fsfi.lis
SQL> /
                                                              

TABLESPACE_NAME                    FSFI
------------------------------  -------
DATA_1                             8.30
SYSAUX                            12.07
SYSTEM                            59.31
UNDO                              64.89
USERS                            100.00

SQL> spool off
SQL>








Related examples in the same category

1.Change user default table space and temporary table space
2.Get default table space for current user
3.Moving Tables To New Tablespaces or Storage
4.heap table
5.Show_space
6.Check space with show_space for an index with compress 1
7.Check space with show_space for an index with compress 2
8.Create two indexes on one table and check the space
9.alter tablespace
10.Map user objects to tablespaces.
11.The plsql user is created using the USERS and TEMP tablespace.