topic Re: index stats in ArcGIS Enterprise Questions

index stats

jayasudha — Mon, 20 Oct 2014 10:49:09 GMT

I am using Oracle 11g R2, spatial tables registered with geodatabase, geometry type is SDO_GEOMETRY.

When i try to get index stats, there is error, please help me.

sdelayer -o si_stats -l road,geometry -i sde:oracle11g:pms -u user -p user

ArcSDE 10.1 for Oracle11g Build 679 Thu Apr 5 11:43:21 2012

Layer Administration Utility

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

Error: The operation requested is unsupported (-210).

Error: Cannot get Map Layer Spatial Index Statistics for the layer

Re: index stats

Anonymous User — Mon, 20 Oct 2014 11:07:41 GMT

Hello

si_stats only works only for binary geometry storage type or ST_Geometry in Oracle (at least until 10.0):

Reports spatial index statistics (only applies to binary geometry storage types in geodatabases in Oracle and SQL Server and the ST_Geometry storage type in Oracle)

in:

http://help.arcgis.com/en/geodatabase/10.0/admin_cmds/support_files/datamgmt/sdelayer.htm#si_stats

Hope this helps

Jesús

Re: index stats

jayasudha — Mon, 20 Oct 2014 11:25:16 GMT

Thanks for that

How can i see the index stats and see grid size, improve grid size in my case ?

Re: index stats

VinceAngelo — Mon, 20 Oct 2014 14:23:49 GMT

MDSYS.SDO_GEOMETRY does not use grids. I don't believe R-TREE has any tuning parameters at all, though the Oracle documentation may have recommendations on improving performance with other index parameters.

- V

Re: index stats

jayasudha — Tue, 21 Oct 2014 05:16:45 GMT

Vince

I am using "rebuild indexes" and "analyze datasets" geoprocessing tool on mdsys.sdo_geometry tables.

Whether it is useful in this case ? Do i need to do the same from Oracle side.

Re: index stats

VinceAngelo — Tue, 21 Oct 2014 15:21:14 GMT

Those tools are run on on the Oracle side. There is no Esri side to SDO_GEOMETRY storage.

- V

Re: index stats

JohnLovato — Wed, 03 Jun 2015 23:33:25 GMT

Vince,

At version 10.3 we no longer have access to the command line tools and sdelayer -o si_stats and se_toolkit sdestats -o si_stats? My users have gotten used to using this tool to analyze their spatial indexes. Is there a way to do this with just SQL inside the Oracle database? Thanks in advance.

Regards,

John P. Lovato

US Forest Service

Geospatial Database Engineer

Re: index stats

VinceAngelo — Wed, 03 Jun 2015 23:57:33 GMT

My "To Do List" job jar includes re-implenting the sdestats utilities in Python or ArcObjects, but I've been too busy. You may be able to run the 10.2.2 tools against a 10.3.x geodatabase safely, especially the read-only tools, but I can't make any guarantees.

- V