column FSFI format 999,99
select tablespace_name,sqrt(max(blocks)/sum(blocks))*(100/sqrt(sqrt(count(blocks)))) FSFI from dba_free_space group by tablespace_name order by 1;
*FSFI 100 is ideal number in the single data file, FSFI less than 30 needs to re-organize the tablespace.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/20500445/viewspace-708595/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- EXP-00091: Exporting questionable statistics
- How to re-install JVM
- How to do oracle database character set migration
- Get the below error after duplicating database
- How to do the batch job (disable/enable constraint)
- ORA-01940: cannot drop a user that is currently connected
- How to get the TOP SQL
- Change the max extents of table
- Fix undo tablespace issue Errors
- ORA-00018: maximum number of sessions exceeded
