OracleݿƬ   (2461) 
---- ֪OracleΪһִݿ⣬㷺Ӧڽڡʵ硢񺽵޴󣬼㷺ռҪšϵͳԱα֤ȶУݿܣʹӰȫЧԵΪҪΪӰݿܵһ--ݿƬӦDBA㹻ӣʱֲƬDBAһάݡ 

---- 1Ƭβ 

---- һݿʱֳɳΪռ䣨TablespaceĶ߼ΣSegmentϵͳSystemռ,ʱTemporaryռȡһռ԰ݷΧExtentһɷΧ飬ɿռ䣨Free Space 

---- ռ䡢ΡΧɿռ߼ϵ£ 



---- ռһʱӱռЧɿռΪεĳʼΧռ䡣ЩʼΧʱλһΧչ̻һֱȥֱﵽķΧֵڱռѾûɿռһΧ״̬һεݿɱڵһһΧСеݴ洢ʱݣѰݿһЩָ롣һΰΧǴڵģûκδʩԱ֤ЩΧڴ洢ģͼ1ҪһռҪʱݿⲻٺϲڵɷΧǱѡ񣩣 ѰұռɷΧʹáγԽԽɢġָġСɿռ䣬Ƭ磺 



---- 2ƬϵͳӰ 

---- ʱƣݿӦϵͳĹ㷺ʹãƬԽԽ࣬ݿҪӰ죺 

---- 1ϵͳܼ 

---- ҪһռҪʱݿ⽫ȲҵǰɷΧ""ɷΧ𽥱СҪҵһ㹻ɷΧѱԽԽѣӶ±ռеٶϰʹݿĿռԶ״̬ 

---- 2˷Ѵıռ 

---- һɷΧռpctincreaseΪ0ᱻSMONϵͳأ̨ԵغϲʼһɷΧ޷Զϲ˷˴ıռ䡣 

---- 3ɷΧƬ 

---- ɿռƬɼɣ緶ΧΧߴȣǿFSFI--Free Space Fragmentation IndexɿռƬֱֵ֣ 

FSFI=100*SQRT(max(extent)/sum(extents))*1/SQRT(SQRT(count(extents)))

---- ԿFSFIֵΪ100һĵļռ䣩ŷΧӣFSFIֵ½Χߴļ٣FSFIֵѸ½ 
---- ĽűFSFIֵ 

rem FSFI Value Compute
rem fsfi.sql
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;
spool fsfi.rep;
/
spool off;

---- 磬ĳݿнűfsfi.sql,õFSFIֵ 
TABLESPACE_NAME FSFI
------------------------------ -------
RBS 74.06
SYSTEM 100.00
TEMP 22.82
TOOLS 75.79
USERS 100.00
USER_TOOLS 100.00
YDCX_DATA 47.34
YDCX_IDX 57.19
YDJF_DATA 33.80
YDJF_IDX 75.55

---- ͳƳݿFSFIֵͿ԰ΪһɱȲһ㹻Чɿռ䣬FSFIֵ30ıռУٻЧɿռ⡣һռ佫ҪӽɱȲʱҪƬˡ 
---- 4ɷΧƬ 

---- 1ռpctincreaseֵΪ0 

---- Խռȱʡ洢pctincreaseΪ0һ㽫Ϊ1磺 

alter tablespace temp
default storage(pctincrease 1);

---- SMONὫɷΧԶϲҲֹϲɷΧ 
alter tablespace temp coalesce;

---- 5εƬ 
---- ֪ɷΧɡЩ£бҪԶεƬҪ鿴εйϢɲ鿴ֵdba_segmentsΧϢɲ鿴ֵdba_extentsεƬ࣬ ѹһΧ򵥷ȷĴ洢ؽȻ󽫾ɱеݲ뵽±ͬʱɾɱ̿Import/Export/ɡ 

---- Exportһѹ־־ڶʱExportȷñռתļдһµĳʼ洢--ȫռ䡣رգ ʹImportɡݻһµġϴĳʼС磺 

exp user/password file=exp.dmp compress=Y grants=Y indexes=Y
tables=(table1,table2);

---- ɹӿɾıȻתļ 
imp user/password file=exp.dmp commit=Y buffer=64000 full=Y

---- ַݿ⡣
 
