-
how do i interprete this output? I got this sql from dbasupport.com
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;
BBI_TOMPASS_A 62.46
BBI_TOMPASS_B 65.38
BBI_TOMPASS_ROLAP_A 58.62
BBI_TOMPASS_ROLAP_B 49.33
BBI_TIMENSION_A 61.41
BBI_TIMENSION_B 44.53
BBI_TSSBASE_A 100.00
BBI_ESSBASE_B 56.66
BBI_SHIPMENTS_A 26.81
BBI_SHIPMENTS_B 49.81
BBI_STAGE 61.37
BBI_TRADE_SPENDING_A 33.50
BBI_TRADE_SPENDING_B 33.76
RB 9.68
SYSTEM 83.97
TEMP 45.09
USERS 84.06
THANKS
jigar
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|