FREE EXTENT FRAGMENTATION IN ORACLE DATABASE

Huang Shui-yuan · Journal of Nanchang University · 2004

This paper analyses the origin of Oracle free extent fragmentation and its effect on Oracle DBMS performance, based on which FSFI calculation model is put forward to evaluate the probability of database acquirement for free space. A small script is presented to map the utilization of some tablespace.The problems of coalition of extents is discussed.

Read the paper · More papers on PaperTik