nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

index stats

jayasudha

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

Trouver plus de publications taguées avec

Accepted answers

All comments

Anonymous User

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

jayasudha

Thanks for that

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

VinceAngelo

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

jayasudha

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.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.