ArcSDE(Oracle)性能优化

最新推荐文章于 2021-04-15 23:36:13 发布
最新推荐文章于 2021-04-15 23:36:13 发布
阅读量1.6k 收藏
点赞数
分类专栏： ArcSDE 文章标签： oracle xml c user 数据库 优化
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/kmblack1/article/details/4538106
版权

 无特殊说明，下述内容中 ArcSDE版本为9.2，Oracle数据库版本为9.2.0.8.0。

 通过设置或调整ArcSDE配置参数优化ArcSDE性能提升不是太大（ArcSDE参数信息http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=ArcSDE_initialization_parameters），建议主要优化Oracle，数据库优化分为以下三步：

    1、内存优化

    ArcSDE安装完成后，不要立即运行Post Installation，应先对数据库内存进行优化。数据库内存优化请参看http://blog.csdn.net/chenanlin1981/archive/2007/04/05/1553160.aspx。

    2、创建存储表空间和SDE用户

    2.1 创建表空间

    可根据磁盘情况创建表空间，普通硬盘尽量把表空间分散在不两只的硬盘上，SCSI无所谓。以下为创建表空间脚本
  ----    创建F表空间SPATIAL_MAP_SPACE_F
Create Tablespace SPATIAL_MAP_SPACE_F
  Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F01.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited Online;
 
Alter Tablespace SPATIAL_MAP_SPACE_F
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F02.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_F
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F03.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_F
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F04.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_F
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F05.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_F
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F06.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;

Alter Tablespace SPATIAL_MAP_SPACE_F
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F07.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_F
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F08.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited; 
 
Alter Tablespace SPATIAL_MAP_SPACE_F
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F09.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_F
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F10.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited; 

 ----    创建F表索引表空间SPATIAL_MAP_SPACE_F_I
 Create Tablespace SPATIAL_MAP_SPACE_F_I
  Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F_I/SPATIAL_MAP_SPACE_F_I01.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited Online; 
 
Alter Tablespace SPATIAL_MAP_SPACE_F_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F_I/SPATIAL_MAP_SPACE_F_I02.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_F_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F_I/SPATIAL_MAP_SPACE_F_I03.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_F_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F_I/SPATIAL_MAP_SPACE_F_I04.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_F_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F_I/SPATIAL_MAP_SPACE_F_I05.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_F_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F_I/SPATIAL_MAP_SPACE_F_I06.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
  ----    创建RAS表空间SPATIAL_RASTER_SPACE
Create Tablespace SPATIAL_RASTER_SPACE
  Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE01.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited Online;
 
Alter Tablespace SPATIAL_RASTER_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE02.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE03.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE04.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE05.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE06.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE07.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE08.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE09.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE10.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;

Alter Tablespace SPATIAL_RASTER_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE11.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE12.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE13.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE14.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE15.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE16.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE17.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE18.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE19.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE20.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
 ----    创建RAS表索引表空间SPATIAL_RASTER_SPACE_I
Create Tablespace SPATIAL_RASTER_SPACE_I
  Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE_I/SPATIAL_RASTER_SPACE_I01.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited Online;

Alter Tablespace SPATIAL_RASTER_SPACE_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE_I/SPATIAL_RASTER_SPACE_I02.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;


Alter Tablespace SPATIAL_RASTER_SPACE_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE_I/SPATIAL_RASTER_SPACE_I03.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE_I/SPATIAL_RASTER_SPACE_I04.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE_I/SPATIAL_RASTER_SPACE_I05.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_RASTER_SPACE_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE_I/SPATIAL_RASTER_SPACE_I06.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
 

  ----    创建S表空间SPATIAL_MAP_SPACE_S
Create Tablespace SPATIAL_MAP_SPACE_S
  Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S/SPATIAL_MAP_SPACE_S01.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited Online;
 
Alter Tablespace SPATIAL_MAP_SPACE_S
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S/SPATIAL_MAP_SPACE_S02.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_S
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S/SPATIAL_MAP_SPACE_S03.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_S
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S/SPATIAL_MAP_SPACE_S04.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_S
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S/SPATIAL_MAP_SPACE_S05.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_S
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S/SPATIAL_MAP_SPACE_S06.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_S
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S/SPATIAL_MAP_SPACE_S07.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_S
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S/SPATIAL_MAP_SPACE_S08.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
  ----    创建S表索引表空间SPATIAL_MAP_SPACE_S_I
 Create Tablespace SPATIAL_MAP_SPACE_S_I
  Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S_I/SPATIAL_MAP_SPACE_S_I01.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited Online;
 
Alter Tablespace SPATIAL_MAP_SPACE_S_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S_I/SPATIAL_MAP_SPACE_S_I02.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;

Alter Tablespace SPATIAL_MAP_SPACE_S_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S_I/SPATIAL_MAP_SPACE_S_I03.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_S_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S_I/SPATIAL_MAP_SPACE_S_I04.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_S_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S_I/SPATIAL_MAP_SPACE_S_I05.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_S_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S_I/SPATIAL_MAP_SPACE_S_I06.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
 
  
----    创建SDE表空间SPATIAL_MAP_SPACE
Create Tablespace SPATIAL_MAP_SPACE
  Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE01.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited Online;
 
Alter Tablespace SPATIAL_MAP_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE02.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE03.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE04.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE05.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE06.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;

Alter Tablespace SPATIAL_MAP_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE07.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE08.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited; 
 
Alter Tablespace SPATIAL_MAP_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE09.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE10.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited; 
 
 ----    创建SDE索引表空间SPATIAL_MAP_SPACE_I
Create Tablespace SPATIAL_MAP_SPACE_I
  Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_I/SPATIAL_MAP_SPACE_I01.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited Online; 
 
Alter Tablespace SPATIAL_MAP_SPACE_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_I/SPATIAL_MAP_SPACE_I02.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_I/SPATIAL_MAP_SPACE_I03.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_I/SPATIAL_MAP_SPACE_I04.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_I/SPATIAL_MAP_SPACE_I05.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_MAP_SPACE_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_I/SPATIAL_MAP_SPACE_I06.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
  

----    创建SDE,XML表空间SPATIAL_XML_SPACE
Create Tablespace SPATIAL_XML_SPACE
  Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE01.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited Online;
 
Alter Tablespace SPATIAL_XML_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE02.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_XML_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE03.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_XML_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE04.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_XML_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE05.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_XML_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE06.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;

Alter Tablespace SPATIAL_XML_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE07.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_XML_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE08.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited; 
 
Alter Tablespace SPATIAL_XML_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE09.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_XML_SPACE
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE10.dbf' size 1024M Reuse
  Autoextend on next 10M Maxsize unlimited; 
 
 ----    创建SDE,XML索引表空间SPATIAL_XML_SPACE_I
Create Tablespace SPATIAL_XML_SPACE_I
  Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE_I/SPATIAL_XML_SPACE_I01.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited Online; 
 
Alter Tablespace SPATIAL_XML_SPACE_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE_I/SPATIAL_XML_SPACE_I02.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_XML_SPACE_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE_I/SPATIAL_XML_SPACE_I03.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_XML_SPACE_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE_I/SPATIAL_XML_SPACE_I04.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_XML_SPACE_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE_I/SPATIAL_XML_SPACE_I05.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
Alter Tablespace SPATIAL_XML_SPACE_I
  Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE_I/SPATIAL_XML_SPACE_I06.dbf' size 1024M reuse
  Autoextend on next 10M Maxsize unlimited;
 
 
 ----    创建临时表空间SPATIAL_TEMP_SPACE
 Create temporary Tablespace SPATIAL_TEMP_SPACE
   TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE01.dbf' size 1024M reuse
   EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M;
 
 Alter Tablespace SPATIAL_TEMP_SPACE
   Add TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE02.dbf' size 1024M Reuse
   Autoextend on next 10M Maxsize unlimited;
  
 Alter Tablespace SPATIAL_TEMP_SPACE
   Add TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE03.dbf' size 1024M Reuse
   Autoextend on next 10M Maxsize unlimited;
  
 Alter Tablespace SPATIAL_TEMP_SPACE
   Add TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE04.dbf' size 1024M Reuse
   Autoextend on next 10M Maxsize unlimited;
  
 Alter Tablespace SPATIAL_TEMP_SPACE
   Add TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE05.dbf' size 1024M Reuse
   Autoextend on next 10M Maxsize unlimited;
 
 Alter Tablespace SPATIAL_TEMP_SPACE
   Add TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE06.dbf' size 1024M Reuse
   Autoextend on next 10M Maxsize unlimited;
  
 Alter Tablespace SPATIAL_TEMP_SPACE
   Add TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE07.dbf' size 1024M Reuse
   Autoextend on next 10M Maxsize unlimited;
  
 Alter Tablespace SPATIAL_TEMP_SPACE
   Add TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE08.dbf' size 1024M Reuse
   Autoextend on next 10M Maxsize unlimited;

 Alter Tablespace SPATIAL_TEMP_SPACE
   Add TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE09.dbf' size 1024M Reuse
   Autoextend on next 10M Maxsize unlimited;

 Alter Tablespace SPATIAL_TEMP_SPACE
   Add TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE10.dbf' size 1024M Reuse
   Autoextend on next 10M Maxsize unlimited;

 

   2.2 创建SDE用户

   建议SDE只存储ArcSDE系统表和系统信息，然后根据用途和数据情况创建其它用户，使用时不要直接使用sde用户。例如有矢量和影像数据，可创建MAP和RASTER用户。根据创建表空间脚本，指定MAP和RASTER用户的默认表空间和临时表空间，创建脚本如下：

 

--修改SYS和SYSTEM默认表空间和临时表空，请根据情况决定是否修改。

Alter USER SYS DEFAULT TABLESPACE SPATIAL_MAP_SPACE;
Alter USER SYS TEMPORARY TABLESPACE SPATIAL_TEMP_SPACE;

Alter USER SYSTEM DEFAULT TABLESPACE SPATIAL_MAP_SPACE;
Alter USER SYSTEM TEMPORARY TABLESPACE SPATIAL_TEMP_SPACE;

--创建空间数据管理角色，这是SDE用户要求的最低权限
DROP ROLE SDE_UPGRADE;
CREATE ROLE SDE_UPGRADE;
GRANT CREATE SESSION  TO SDE_UPGRADE;
GRANT CREATE TABLE   TO SDE_UPGRADE;
GRANT CREATE PROCEDURE  TO SDE_UPGRADE;
GRANT CREATE SEQUENCE  TO SDE_UPGRADE;
GRANT CREATE TRIGGER  TO SDE_UPGRADE;
GRANT CREATE TYPE   TO SDE_UPGRADE;
GRANT CREATE LIBRARY  TO SDE_UPGRADE;
GRANT CREATE PUBLIC SYNONYM TO SDE_UPGRADE;
GRANT DROP PUBLIC SYNONYM TO SDE_UPGRADE;
GRANT ALTER ANY INDEX  TO SDE_UPGRADE;
GRANT ALTER ANY TABLE  TO SDE_UPGRADE;
GRANT ANALYZE ANY   TO SDE_UPGRADE;
GRANT CREATE ANY INDEX  TO SDE_UPGRADE;
GRANT DROP ANY INDEX  TO SDE_UPGRADE;
GRANT CREATE ANY PROCEDURE TO SDE_UPGRADE;
GRANT DROP ANY PROCEDURE TO SDE_UPGRADE;
GRANT CREATE ANY SEQUENCE TO SDE_UPGRADE;
GRANT DROP ANY SEQUENCE  TO SDE_UPGRADE;
GRANT CREATE ANY TRIGGER TO SDE_UPGRADE;
GRANT CREATE ANY VIEW  TO SDE_UPGRADE;
GRANT DROP ANY TABLE  TO SDE_UPGRADE;
GRANT DROP ANY VIEW   TO SDE_UPGRADE;
GRANT EXECUTE ANY PROCEDURE TO SDE_UPGRADE;
GRANT SELECT ANY SEQUENCE TO SDE_UPGRADE;
GRANT SELECT ANY TABLE  TO SDE_UPGRADE;
GRANT CREATE OPERATOR  TO SDE_UPGRADE;
GRANT CREATE INDEXTYPE  TO SDE_UPGRADE;

 

  ----    创建ArcSDE用户sde,密码为

 ----    用户使用表空间SPATIAL_MAP_SPACE；临时表空间为SPATIAL_TEMP_SPACE
CREATE USER "SDE" IDENTIFIED BY "密码" DEFAULT TABLESPACE SPATIAL_MAP_SPACE TEMPORARY TABLESPACE SPATIAL_TEMP_SPACE;
GRANT UNLIMITED TABLESPACE TO SDE;
GRANT SDE_UPGRADE TO SDE;

 

--创建矢量数据管理用户 
CREATE USER "MAP" IDENTIFIED BY "密码" DEFAULT TABLESPACE SPATIAL_MAP_SPACE TEMPORARY TABLESPACE SPATIAL_TEMP_SPACE;
GRANT UNLIMITED TABLESPACE TO MAP;
GRANT SDE_UPGRADE TO MAP;

--创建栅格数据管理用户 
CREATE USER "RASTER" IDENTIFIED BY "密码" DEFAULT TABLESPACE SPATIAL_RASTER_SPACE TEMPORARY TABLESPACE SPATIAL_TEMP_SPACE;
GRANT UNLIMITED TABLESPACE TO RASTER;
GRANT SDE_UPGRADE TO RASTER;

3、修改dbtune表配置信息

    dbtune表信息参看（http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=DBTUNE_configuration_parameter_name-configuration_string_pairs）

    导出
sdedbtune -o export -f "c:/dbtune.txt" -i esri_sde -s 服务器名或IP -D 数据库名称 -u sde -p sde密码

    导入
sdedbtune -o import -f c:/dbtune.txt -i esri_sde -s 服务器名或IP -D 数据库名称 -u sde -p sde密码

打开c:/dbtune.txt，增加以下内容，添加一个配置关键字MAP。使用该关键时，根据数据类型数据存储到指定的表空间。


##MAP
UI_TEXT      "User Interface text description for MAP"

A_INDEX_ROWID    "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4  NOLOGGING"
A_INDEX_STATEID    "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4  NOLOGGING"
A_INDEX_USER    "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4  NOLOGGING"
A_INDEX_XML     "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4  NOLOGGING"
A_STORAGE     "TABLESPACE SPATIAL_MAP_SPACE_S   PCTFREE 0 INITRANS 4  NOLOGGING"
AUX_INDEX_COMPOSITE   "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4  NOLOGGING"
AUX_STORAGE     "TABLESPACE SPATIAL_MAP_SPACE_S   PCTFREE 0 INITRANS 4  NOLOGGING"

B_INDEX_RASTER    "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_ROWID    "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_SHAPE    "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_TO_DATE    "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_USER     "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_XML     "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
B_STORAGE     "TABLESPACE SPATIAL_RASTER_SPACE   PCTFREE 0 INITRANS 4  NOLOGGING"
BLK_INDEX_COMPOSITE   "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
BLK_STORAGE     "TABLESPACE SPATIAL_RASTER_SPACE   PCTFREE 0 INITRANS 4  NOLOGGING"
BND_INDEX_COMPOSITE   "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
BND_INDEX_ID    "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
BND_STORAGE     "TABLESPACE SPATIAL_RASTER_SPACE   PCTFREE 0 INITRANS 4  NOLOGGING"

D_INDEX_DELETED_AT   "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4  NOLOGGING"
D_INDEX_STATE_ROWID   "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4  NOLOGGING"
D_STORAGE     "TABLESPACE SPATIAL_MAP_SPACE_S   PCTFREE 0 INITRANS 4  NOLOGGING"

F_INDEX_AREA    "TABLESPACE SPATIAL_MAP_SPACE_F_I PCTFREE 0 INITRANS 4  NOLOGGING"
F_INDEX_FID     "TABLESPACE SPATIAL_MAP_SPACE_F_I PCTFREE 0 INITRANS 4  NOLOGGING"
F_INDEX_LEN     "TABLESPACE SPATIAL_MAP_SPACE_F_I PCTFREE 0 INITRANS 4  NOLOGGING"
F_STORAGE     "TABLESPACE SPATIAL_MAP_SPACE_F PCTFREE 0 INITRANS 4  NOLOGGING"

LD_INDEX_DATA_ID   "TABLESPACE SPATIAL_MAP_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
LD_INDEX_ROWID    "TABLESPACE SPATIAL_MAP_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
LD_STORAGE     "TABLESPACE SPATIAL_MAP_SPACE   PCTFREE 0 INITRANS 4  NOLOGGING"
LF_INDEXES     "TABLESPACE SPATIAL_MAP_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
LF_STORAGE     "TABLESPACE SPATIAL_MAP_SPACE   PCTFREE 0 INITRANS 4  NOLOGGING"

MVTABLES_MODIFIED_INDEX  "TABLESPACE SPATIAL_MAP_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
MVTABLES_MODIFIED_TABLE  "TABLESPACE SPATIAL_MAP_SPACE   PCTFREE 0 INITRANS 4  NOLOGGING"

RAS_INDEX_ID    "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
RAS_STORAGE     "TABLESPACE SPATIAL_RASTER_SPACE   PCTFREE 0 INITRANS 4  NOLOGGING"
RDT_INDEX_COMPOSITE   "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
RDT_STORAGE     "TABLESPACE SPATIAL_RASTER_SPACE   PCTFREE 0 INITRANS 4  NOLOGGING"

S_INDEX_ALL     "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4  NOLOGGING"
S_INDEX_SP_FID    "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4  NOLOGGING"
S_STORAGE     "TABLESPACE SPATIAL_MAP_SPACE_S   PCTFREE 0 INITRANS 4  NOLOGGING"
SDO_INDEX_SHAPE    "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4  NOLOGGING"
SESSION_INDEX    "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4  NOLOGGING"
SESSION_STORAGE    "TABLESPACE SPATIAL_MAP_SPACE_S   PCTFREE 0 INITRANS 4  NOLOGGING"
ST_GEOM_LOB_STORAGE   "TABLESPACE SPATIAL_MAP_SPACE_S   PCTFREE 0 INITRANS 4  NOLOGGING"
STATES_INDEX    "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4  NOLOGGING"
STATES_TABLE    "TABLESPACE SPATIAL_MAP_SPACE_S   PCTFREE 0 INITRANS 4  NOLOGGING"

VERSIONS_INDEX    "TABLESPACE SPATIAL_MAP_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
VERSIONS_TABLE    "TABLESPACE SPATIAL_MAP_SPACE PCTFREE 0 INITRANS 4  NOLOGGING"

XML_DOC_INDEX    "TABLESPACE SPATIAL_XML_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
XML_DOC_STORAGE    "TABLESPACE SPATIAL_XML_SPACE PCTFREE 0 INITRANS 4  NOLOGGING"
XML_IDX_INDEX_DOUBLE  "TABLESPACE SPATIAL_XML_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
XML_IDX_INDEX_ID   "TABLESPACE SPATIAL_XML_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
XML_IDX_INDEX_PK   "TABLESPACE SPATIAL_XML_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
XML_IDX_INDEX_STRING  "TABLESPACE SPATIAL_XML_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
XML_IDX_INDEX_TAG   "TABLESPACE SPATIAL_XML_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
XML_IDX_INDEX_TEXT   "TABLESPACE SPATIAL_XML_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
XML_IDX_STORAGE    "TABLESPACE SPATIAL_XML_SPACE PCTFREE 0 INITRANS 4  NOLOGGING"
XML_INDEX_TAGS_INDEX  "TABLESPACE SPATIAL_XML_SPACE_I PCTFREE 0 INITRANS 4  NOLOGGING"
XML_INDEX_TAGS_TABLE  "TABLESPACE SPATIAL_XML_SPACE PCTFREE 0 INITRANS 4  NOLOGGING"

END

导入c:/dbtune.txt 后，用catalog连接到SDE点击右键属性打开属性信息，如下图

点击configuration Keywords打开配置关键字信息窗口

第二行就是我们创建的关键字

 

kmblack1
关注
专栏目录
ArcSDE及oracle安装配置大汇总
08-28
汇总了当前网络上比较流行的arcsde及oracle安装配置教程，资料齐全，绝对好东东。
ArcSDE和Oracle空间数据库探索
最新发布
03-08
最后，谈到性能，ArcSDE在某些操作上显示出了更高的效率，这可能是由于其优化的索引策略和对数据库系统的深入集成。然而，具体性能比较还需根据实际应用场景和数据量来确定，因为每个系统都有其特定的性能优势和使用...
SDE+ORACLE优化配置
weixin_33736649的博客
10-31 174
原文 SDE+ORACLE优化配置   SDE的性能取决于： 首先操作系统的性能；其次是Oracle的性能，再次是SDE的性能。 第一：操作系统，无非是内存、CPU、带宽等。 可以有待提高的地方：第一、硬件升级； 第二、磁盘速度，用RAID集中存储会比服务器硬盘速度快。 第三、做LB，负载均衡。比如可以用OrcleRAC。 第二：Oracle的性能 Oracle可以调优的地...
ArcSDE/Oracle的简单优化(图层和索引分开)
junmail的专栏
07-10 250
1.SDE的性能主要还是取决于Oracle的性能，然后才是SDE, SDE的优化只能提高较小的性能（就我的情况来看）。2. 在用arcCatalog导入oracle时，最好把图层表和索引分开，一般情况下，默认是导入到SDE系统用户下的表空间中：a.创建两个表空间，用于存储Table and index.b. modify %SDEHOME/etc/dbtune.sde file，add keywo...
ArcSDE检测优化工具--egdbhealth
吃好喝好，好好学习，好好工作
03-29 368
一、简介 用于监控企业级地理数据库，并对运行状态提供相应参考意见。目前只支持Oracle、PG、Sql Server以及ArcGIS Datastore(pg) 本工具使用难度较大，需要结合数据库知识，比较合适的使用方式是，dba结合报告对数据库进行优化处理。 二、使用过程 2.1 前提 目前只支持Oracle、Sql Server、PG、SAP...
oracle给序列加高速缓存,ArcSDE性能优化-对于SDE 库更改 Oracle 序列的高速缓存大小...
weixin_39958137的博客
04-15 489
介绍一下：exec sys.DBMS_SHARED_POOL.KEEP-- Keep an object in the shared pool. Once an object has been keeped in-- the shared pool, it is not subject to aging out of the pool. This-- may be useful ...
ArcSDE for Oracle优化实践.pdf
10-10
《ArcSDE for Oracle 优化实践》这篇文章主要探讨了在使用ArcSDE for Oracle时遇到的性能问题及其解决方案，特别关注了关系型数据库的优化，旨在提高空间数据库的效率和响应速度。 ArcSDE是ESRI公司的一款产品，它...
ArcSDE 10.2 FOR Oracle10g、11g安装包
08-08
7. **性能优化**：ArcSDE可以利用Oracle的特性，如索引、分区和并行查询，提高数据检索速度。同时，通过合理配置ArcSDE和Oracle参数，可以进一步优化系统性能。 8. **安全性和备份**：ArcSDE支持Oracle的安全机制，...
基于ArcSDE Oracle模式的海量空间数据库建设.pdf
10-09
本文将详细探讨这种模式的空间数据库存储、数据库性能优化以及安全措施。 1. 数据库存储 矢量数据的存储在ArcSDE中主要依赖于业务表、要素表和空间索引表。业务表是用户直接交互的部分，而其他表格由SDE自动维护。...
ArcSDE for Oracle配置和调整初步【转】
weixin_30892987的博客
07-04 127
一、主要内容 影响ArcSDE性能的因素很多，但是归根到底包括两个方面，后台的Oracle和ArcSDE的配置。Oracle方面，不仅包含数据库组件大小定义、存储参数等内容，还包括Oracle实例的初始化参数、Oracle统计信息分析等内容。ArcSDE方面包括DBTUNE存储参数、空间索引、以及统计信息更新等方面。作为建立在后台数据库系统之上的空间数据库引擎，ArcSDE的性能很大程度上取...
arcsde10.0和10.1 连接oracle11g的参数。亲测通过
05-17
自己用arcsde连接oracle时，做的笔记
基于Oracle数据库与ArcSDE的空间数据存取优化* (2011年)
05-22
随着空间信息技术不断发展,以及Or acle数据库规模的不断扩大、容量的不断增加,对Or acle数据库的性能的要求也不断提高。如何提高Or acle数据库的效率,如何解决海量空间数据的优化问题,成为数据库管理员面临的一个重要课题。在实际应用Or acle数据库和ArcSDE空间数据库引擎的过程中,逐步总结了与空间信息访问速度息息相关的数据库服务器配置和ArcSDE (Sapatial Data Engine)空间数据库引擎配置两个主要方面的优化方法。通过调整组成SGA (System Global Ar
ArcSDE使用及优化 收集
在路上cheny的专栏
02-20 539
以下为收集整理的关于ArcSDE使用及优化的一些问题，供自己和大家参考 1. ArcSDE连接方式 2.ArcSDE 连接数及设置          请参考  尤文G斯 的文章  ArcSDE连接数设置及其性能说明 3.ArcSDE自动剔除无效连接
SDE优化：oracle参数调整
小小的天空
03-31 1567
今天突然接到BOSS电话，问一年前做性能测试时如何对Arcgis server和SDE中oracle做的调整，于是翻了以前的文档，看到了Arcgis server中主要是调整JVM和空闲线程数，而SDE调整的参数就比较多，但是记得当时管用的就是cursor数。 以下是oracle可调整的参数： 1.1.    Open_cursors 初始化参数Open_cursors规定了一个会话
使用Oracle内存机制优化ArcSDE图层空间查询的实验
rrrrssss00的专栏
12-17 1554
最近看了一些关于Oracle的Buffer Cache和Keep Pool的文章，有了一些想法：如果把ArcSDE的图层或索引加载到内存里，会不会提升查询的速度呢？ 相关的介绍文章如下： http://blog.csdn.net/leshami/article/details/6208594 http://blog.csdn.net/tianlesoftware/article/detail
ArcSDE性能优化系列之索引篇
热门推荐
积思园
03-23 1万+
一说到ArcSDE性能优化的问题，相信好多用户会提到索引，是的索引是会提高我们的查询性能，本文重点说明一下ArcSDE的空间索引的运行机制，以及原理。 说明一下，本文是对在SDE库里面的一个面状图层（DLT）进行相关的系列研究，当我们将该数据导入到SDE库里面，只要是通过Arc
ArcSDE性能优化-对于SDE 库更改 Oracle 序列的高速缓存大小
05-11 367
ArcSDE用户中 • state_id_generator_nc  • connection_id_generator  • version_id_generator 三个序列经常使用，但是默认的Cache SIZE等于0 Oracle 序列是一个数据库对象，提供唯一的整数值。序列高速缓存的大小决定多少 Oracle 预前分配在内存中，在共享池中的值。通过预分配值，Oracle 将
基于ArcSDE的Oracle配置
marquess的专栏
01-13 1950
在关系数据库管理系统（DBMS）中，ArcSDE就像管理地理数据的“大门”，使得DBMS中数据可以快速向ArcMap、ArcCatalog、ArcIMS，以及其它互联网络客户端传输。ArcSDE和DBMS的组合使用，有利于将基于传统文件的矢量，栅格和CAD数据都移植到一个空间数据及属性数据集成的数据库中。这样，所有的空间数据及一般的商业数据都被管理在传统IT框架内，有利于数据的一体化。ArcSDE
arcsde 连接oracle ,配置空间数据库（附带史上最全oracle安装步骤）
往事随风的博客
12-18 3615
想好好的来一次排版，让大家看的舒服我也写的舒服，可是一到写的时候，又不知道如何去下手。。。算了直接一步步来吧。                  加油！你是最土的~~ 首先我们要进行准备工作，那就是先装好oralce 11g的服务端和客户端，要是32位的，64位的我不知道行不行， oracle服务端：（为了节省时间我直接简述+贴图片了） 1、双击安装： 2、配置安全更新：不接收安全更...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

kmblack1

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值