ArcSDE/Oracle的简单优化(图层和索引分开)

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.