Database Administration (MOSC)

MOSC Banner

oracle tablespace fragment question

edited Nov 26, 2009 1:27PM in Database Administration (MOSC) 2 commentsAnswered
 our customer said use that  sql check  tablespace  fragment   (db is oracle 10g)

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;

 

-- they said FSFI(Free Space Fragmentation  Index ) value =100 ,means no tablespace fragment, the smaller the value,the much bigger

 Space Fragmentation  .

so they haver several question .

1.how to check tablespace  fragment  ,which sql.?

2.in 10g ,does tablespace fragment will effect the db performance ,does it critical ,how they effect db performance ?

3.what action can use to  resolve  the tablespace  fragment  ?

4.can we use

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center