HOW TO
Instructions provided describe how to discover how much storage is being consumed by an st_geometry spatial index, by querying an Oracle table using the spatial index's name.
Code:
SQL> SELECT geom_id
2 FROM sde.st_geometry_columns
3 WHERE owner = USER
4 AND table_name = 'TAXLOTS';
GEOM_ID
----------
32
Code:
SQL> SELECT tablespace_name, blocks, bytes, extents
2 FROM user_segments
3 WHERE segment_name = 'S32$_IX1';
TABLESPACE_NAME BLOCKS BYTES EXTENTS
--------------- ---------- ---------- ----------
USERS 10096 82706432 631
Note:
The geom_id value from step 1 is embedded in the segment_name as 'S<geom_id>$_IX1'.
Get help from ArcGIS experts
Download the Esri Support App