http://junmail.javaeye.com/blog/213323
1.SDE的性能主要还是取决于Oracle的性能，然后才是SDE, SDE的优化只能提高较小的性能（就我的情况来看）。
2. 在用arcCatalog导入oracle时，最好把图层表和索引分开，一般情况下，默认是导入到SDE系统用户下的表空间中：
a.创建两个表空间，用于存储Table and index.
b. modify %SDEHOME/etc/dbtune.sde file，add keyword info：
#Example:
##SDE_CITY
UI_TEXT "User Interface text description for SDE_CITY"
B_STORAGE "TABLESPACE TABLE_SPACE _NAME PCTFREE 10 PCTUSED 90 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"
F_STORAGE "TABLESPACE TABLE_SPACE _NAME PCTFREE 10 PCTUSED 90 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"
S_STORAGE "TABLESPACE TABLE_SPACE _NAME PCTFREE 10 PCTUSED 90 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"
A_STORAGE "TABLESPACE TABLE_SPACE _NAME PCTFREE 10 PCTUSED 90 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"
A_INDEX_SHAPE "TABLESPACE INDEX_SPACE _NAME PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"
A_INDEX_USER "TABLESPACE INDEX_SPACE _NAME PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"
A_INDEX_ROWID "TABLESPACE INDEX_SPACE _NAMEPCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"
A_INDEX_STATEID "TABLESPACE INDEX_SPACE _NAME PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"
B_INDEX_ROWID "TABLESPACE INDEX_SPACE _NAME PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"
B_INDEX_SHAPE "TABLESPACE INDEX_SPACE _NAME PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"
B_INDEX_ROWID "TABLESPACE INDEX_SPACE _NAME PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"
B_INDEX_USER "TABLESPACE INDEX_SPACE _NAME PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"
D_INDEX_DELETED_AT "TABLESPACE INDEX_SPACE _NAME PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"
D_INDEX_STATE_ROWID "TABLESPACE INDEX_SPACE _NAME PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"
F_INDEX_FID "TABLESPACE INDEX_SPACE _NAME PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"
F_INDEX_AREA "TABLESPACE INDEX_SPACE _NAME PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"
F_INDEX_LEN "TABLESPACE INDEX_SPACE _NAME PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"
S_INDEX_ALL "TABLESPACE INDEX_SPACE _NAME PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"
S_INDEX_SP_FID "TABLESPACE INDEX_SPACE _NAME PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"
END
c. sdedbtune -o import -f dbtune.sde -u XXX -p ***
if successed, you will get the info like this:
Attribute Administration Utility
-----------------------------------------------------
Import DBTUNE Table. Are you sure? (Y/N): y
Successfully imported from file "/xxx/xxx/dbtune.sde"
d. ArcCatalog--> import-->Feature class-->Geodatabase Settings(optional), 如果在下拉框中找到SDE_CITY，则在import过程中，保持选种状态，如果没有找到，查看一下上述修改是否正确。
e. ArcCatalog-->对已经导入的Fearture class -->Analyze.