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

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