Oracle 查询数据库碎片和和历史会话

查看历史会话信息，然后根据会话id或sqlid查询sql

select * from v$active_session_history;

查询表空间碎片率
select a.tablespace_name,
       sqrt(max(a.blocks) / sum(a.blocks)) *
       (100 / sqrt(sqrt(count(a.blocks)))) FSFI
  from dba_free_space a, dba_tablespaces b
 where a.tablespace_name = b.tablespace_name
   and b.contents not in ('TEMPORARY', 'UNDO')
 group by a.tablespace_name
 order by 2;