Home » RDBMS Server » Server Administration » FSFI- need fast reply
FSFI- need fast reply [message #50834] Wed, 10 April 2002 04:51 Go to next message
Ned
Messages: 7
Registered: December 2001
Junior Member
After running this query we get some numbers.

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;

Does anybody knows exactly what is happening.
100 suppose to be not fragmented
or I am wrong? 30 and lower should be fragmented or not?
Ned

Report message to a moderator

Re: FSFI- need fast reply [message #50835 is a reply to message #50834] Wed, 10 April 2002 06:11 Go to previous messageGo to next message
saleem
Messages: 65
Registered: January 2002
Member
interesting query, can't spend much time on it but i'm not sure what it's trying to tell you. when you find out please post the explanation.

Thanks

Report message to a moderator

Re: FSFI- need fast reply - Still not sure [message #50839 is a reply to message #50834] Wed, 10 April 2002 07:27 Go to previous messageGo to next message
Ned
Messages: 7
Registered: December 2001
Junior Member
That interested query I found on this page in the bottom:
http://udlcomputing.cjb.com/udl/training/o8dba/dbaextramaterials-9.htm

Report message to a moderator

Re: FSFI- need fast reply [message #50851 is a reply to message #50834] Thu, 11 April 2002 00:42 Go to previous message
Ned
Messages: 7
Registered: December 2001
Junior Member
No answers, it looks like: bigger number better status.

Report message to a moderator

Previous Topic: Constraint Problem
Next Topic: Oracle Installation error on Sco Unixware
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 08 13:33:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.