Queries the size of the elements, spatial indexes, and attribute indexes stored in the Oracle database.

Some users may have such questions that I have physical sizes in the form of files (either GDB or Shapefile), but how do I know the physical size of a layer stored in the ArcSDE database, and the related index size? For details about the internal indexing mechanism of ArcSDE, refer to blog. csdn. netlinghe301archive20110323.

Some users may have such questions that I have physical sizes in the form of files (either GDB or Shapefile), but how do I know the physical size of a layer stored in the ArcSDE database, and the related index size? For the internal index mechanism of ArcSDE, refer to the http://blog.csdn.net/linghe301/archive/2011/03/23/.

Some users may have such questions that I have physical sizes in the form of files (either GDB or Shapefile), but how do I know the physical size of a layer stored in the ArcSDE database, and the related index size?

For details about the internal indexing mechanism of ArcSDE, refer

Http://blog.csdn.net/linghe301/archive/2011/03/23/6269847.aspx

For example, if I query a layer named FW2

1: query the attribute index name of the layer.

SQL> select index_name from user_indexes where table_name = 'fw2 '; INDEX_NAME------------------------------R541_SDE_ROWID_UKSYS_IL0000085622C00027 $ A372_IX1

You can obtain R541_SDE_ROWID_UK as the attribute index name.

2: query the storage size of the index.

SQL> select bytes from user_segments where segment_name = 'r541 _ done'; BYTES ---------- 393216SQL> select bytes/1024/1024 as bytes from user_segments where segment_name = 'r541 _ done'; property_Index_MB limit. 375

3: query the storage size of the layer.

SQL> select bytes/1024/1024 as table_MB from user_segments where segment_name = 'fw2 '; TABLE_MB ---------- 6SQL> select bytes from user_segments where segment_name = 'fw2'; BYTES ---------- 6291456

4: query the storage size of spatial indexes

First, obtain the geom_id of the layer.

SQL> select geom_id from sde. st_geometry_columns where table_name = 'fw2 '; GEOM_ID ---------- 440

Obtain the spatial index name based on this ID. Generally, the spatial index name is $ _ IX1'

SQL> select bytes/1024/1024 as SpatialIndex_MB from user_segments where segment_name = 's440 $ _ IX1 'else -------- 4SQL> select bytes as SpatialIndex_MB from user_segments where segment_name = 's440 $ _ IX1 '; spatialIndex_MB ---------- 4194304