ArcSDE/Oracle Optimization

Http://junmail.javaeye.com/blog/213323

1. The performance of Sde mainly depends on the performance of Oracle, followed by SDE. The optimization of Sde can only improve a small amount of performance (in my opinion ).
2. When importing Oracle using arccatalog, it is best to separate the layer table from the index. Generally, it is imported to the tablespace of the SDE system user by default:
A.Create two tablespaces to store tables and indexes.
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 "tablespaceIndex_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 _ name Pctfree 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 "tablespaceIndex_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/dbtune. Sde"
D. arccatalog --> Import --> feature class --> Geodatabase settings (Optional). If the sde_cityIn the import process, keep the optional state. If not found, check whether the above modification is correct.
E. arccatalog --> import the imported fearture class --> analyze.