ArcSDE Oracle的存储DBTune配置

 目的：

    将一批数据导入到ArcSDE Oracle里面，考虑到数据量较大。考虑到以后的访问速度，就对数据存储进行了一下配置。配置的思想是将将表格和索引存储在不同的磁盘上，从而降低Oracle磁盘I/O，提高数据的访问速度。
    把SDE系统表和用户数据库表存在不同的表空间中，可以提高I/O上的性能，减少冲突。（但如果服务器是RAID型磁盘阵列，则没必要把用户数据库SDE系统表空间分开。――陈杰）

• 创建存储SDE数据库Feature类的表空间：

CREATE SMALLFILE TABLESPACE "SDE_DATA" DATAFILE 'E:/SDEDB/sde_data01.dbf' SIZE 100M AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

ALTER DATABASE DATAFILE 'E:/SDEDB/SDE_DATA01.DBF' RESIZE 300M

• 创建存储SDE索引的表空间：

CREATE SMALLFILE TABLESPACE "SDE_INDEX" DATAFILE 'E:/SDEDB/sde_index01.dbf' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

 

• DBTUNE参数配置

导出dbtune文件：

C:/ >sdedbtune -o export -f e:/orcl.sanlavo.dbtune.txt -s spf -u sde -p sde

ArcSDE 9.2  for Oracle10g Build 1081 Sun Sep 17 16:01:22  2006

Attribute        Administration Utility

-----------------------------------------------------

 Successfully exported to file "e:/orcl.sanlavo.dbtune.txt"

        on server spf

•  在导出的dbtune参数文件中末尾加上如下参数组：

 

##SDEDATA

#COMMENT This configuration keyword is dedicated to load the data of SDE

B_STORAGE          "TABLESPACE SDE_DATA PCTFREE 10 PCTUSED 90 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"

F_STORAGE         "TABLESPACE SDE_DATA PCTFREE 10 PCTUSED 90 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"

S_STORAGE         "TABLESPACE SDE_DATA PCTFREE 10 PCTUSED 90 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"

A_STORAGE         "TABLESPACE SDE_DATA PCTFREE 10 PCTUSED 90 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"

A_INDEX_SHAPE         "TABLESPACE SDE_INDEX PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"

A_INDEX_USER           "TABLESPACE SDE_INDEX PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"

A_INDEX_ROWID               "TABLESPACE SDE_INDEX PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"

A_INDEX_STATEID      "TABLESPACE SDE_INDEX PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"

B_INDEX_ROWID               "TABLESPACE SDE_INDEX PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"

B_INDEX_SHAPE         "TABLESPACE SDE_INDEX PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"

B_INDEX_ROWID               "TABLESPACE SDE_INDEX PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"

B_INDEX_USER           "TABLESPACE SDE_INDEX PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"

D_INDEX_DELETED_AT      "TABLESPACE SDE_INDEX PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"

D_INDEX_STATE_ROWID   "TABLESPACE SDE_INDEX PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"

F_INDEX_FID              "TABLESPACE SDE_INDEX PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"

F_INDEX_AREA           "TABLESPACE SDE_INDEX PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"

F_INDEX_LEN             "TABLESPACE SDE_INDEX PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"

S_INDEX_ALL             "TABLESPACE SDE_INDEX PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"

S_INDEX_SP_FID               "TABLESPACE SDE_INDEX PCTFREE 10 INITRANS 4 STORAGE (FREELISTS 4 MINEXTENTS 1 MAXEXTENTS UNLIMITED)"

END

编辑完成后把dbtune文件导入sde表空间：

Dbtune表中将多了我们添加的sdedata关键字了。

C:/>sdedbtune -o import -f E:/SDEDB/orcl.sanlavo.dbtune.txt -s spf -u sde -p sde

ArcSDE 9.2  for Oracle10g Build 1081 Sun Sep 17 16:01:22  2006

Attribute        Administration Utility

-----------------------------------------------------

Import DBTUNE Table. Are you sure? (Y/N): y

     Successfully imported from file "E:/SDEDB/orcl.sanlavo.dbtune.txt"

• 更新dbtune表，使我们加入的关键字SDEDATA可用

由于更新DBTUNE表后，导入数据到SDE数据库中，我们的参数并不可用，从ArcGIS Server Help帮助文档中发现如下信息：

Making configuration keywords available in ArcGIS

About user interface parameters

NOTE: ArcSDE Enterprise only

ArcGIS users can specify configuration keywords when they create datasets. To make configuration keywords accessible to ArcGIS Desktop users, you must have a user interface (UI) storage parameter in the configuration keyword's parameter group. Any configuration keywords that do not have a UI storage parameter will not be available to the ArcGIS users.

The UI storage parameters are

UI_TEXT—General user interface storage parameter; to be used with any keyword, other than network or topology keywords, you want to make available to users

UI_NETWORK_TEXT—User interface storage parameter for a parent network keyword

UI_TOPOLOGY_TEXT—User interface storage parameter for a parent topology keyword

UI_TERRAIN_TEXT—User interface storage parameter for a parent terrain keyword

These parameters are present in most of the keyword parameter lists of the default dbtune.sde file. However, if you create your own keywords that you want to be available to ArcGIS users, you should add the appropriate UI storage parameter to the keyword's parameter list.

NOTE: A UI storage parameter is not needed and should not be added to the DATA_DICTIONARY configuration keyword parameter list. The DATA_DICTIONARY configuration keyword is used to specify storage of the ArcSDE geodatabase system tables and cannot be used for datasets.

Some rules about adding user interface storage parameters

· If there are no UI storage parameters in a configuration keyword parameter group, the configuration keyword will not be recognized by ArcGIS or ArcObjects.

· You shouldn't have more than one UI parameter per configuration keyword. For example, you shouldn't have both UI_TEXT and UI_NETWORK_TEXT in the same configuration keyword parameter group.

· If multiple UI storage parameters are present, ArcGIS will only recognize one of them. If UI_TEXT and UI_NETWORK_TEXT or UI_TOPOLOGY_TEXT or UI_TERRAIN_TEXT are in the same group, UI_TEXT will be ignored and the other parameter will be recognized.

 发现UI_TEXT参数的重要性后，加上该参数，详细如下。

1.重新用sdedbtune工具导出配置参数文件：

C:/>sdedbtune -o export -f e:/dbtune.customs.txt -s spf -u sde -p sde

ArcSDE 9.2  for Oracle10g Build 1081 Sun Sep 17 16:01:22  2006

Attribute        Administration Utility

-----------------------------------------------------

       Successfully exported to file "e:/dbtune.customs.txt"

        on server spf

2.打开文件"e:/dbtune.customs.txt"，给SDEDATA关键字中加入

UI_TEXT                    "User Interface text description for SDEDATA"

3.导入sde系统表中：

C:/>sdedbtune -o import -f e:/dbtune.customs.txt -s spf -u sde -p sde

 

ArcSDE 9.2  for Oracle10g Build 1081 Sun Sep 17 16:01:22  2006

Attribute        Administration Utility

-----------------------------------------------------

Import DBTUNE Table. Are you sure? (Y/N): y

        Successfully imported from file "e:/dbtune.customs.txt"

在导入数据对话框中，在Geodatabase Settings(Optional)下面的Configuration Keyword(Optional)下拉列表中选择SDEDATA，即可采用我们的方案存储数据了！

转注：

对于Oracle，以上的方法是将数据存储在制定的数据文件中，而不是方案。