FYR
It takes 7 Sec in 9.3 and 17 Sec in 10.1
ArcSDE 9.3 for Oracle11g Build 546 Thu Sep 18 12:35:50 2008
Layer Administration Utility
-----------------------------------------------------
Layer Description ....: <None>
Table Owner ..........: TEST
Table Name ...........: TABLEABC
Spatial Column .......: SHAPE
Layer Id .............: 8930
SRID .................: 406
Minimum Shape Id .....: 1
Offset ...............:
falsex: -10000.000000
falsey: -10000.000000
System Units .........: 819200000.000000
Z Offset..............: 0.000000
Z Units ..............: 1.000000
Measure Offset .......: <None>
Measure Units ........: <None>
XY Cluster Tolerance .: 0.00002
Spatial Index ........:
parameter: SPIDX_GRID,GRID0=0.29,GRID1=1.16,FULL
exist: Yes
array form: 0.29,1.16,0
Layer Envelope .......:
minx: 31.09743, miny: 14.53603
maxx: 55.69328, maxy: 34.39108
Entities .............: nac+
Layer Type ...........: SDE
Creation Date ........: Wed Sep 26 09:55:23 2012
I/O Mode .............: NORMAL
Autolocking ..........: Enabled
Precision.............: High
User Privileges ......: SELECT, UPDATE, INSERT, DELETE
Coordinate System ....: GEOGCS["GCS_Ain_el_Abd_1970",DATUM["D_Ain_el_Abd_1970",SPHEROID["International_1924",6378388.0,297.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
Layer Configuration ..: DEFAULTS
ArcSDE 10.1 for Oracle11g Build 768 Thu Aug 23 15:57:13 2012
Layer Administration Utility
-----------------------------------------------------
Layer Description ....: <None>
Table Owner ..........: TEST
Table Name ...........: TABLEABC
Spatial Column .......: SHAPE
Layer Id .............: 219
SRID .................: 5
Auth SRID.............: 4204
Minimum Shape Id .....: 1
Offset ...............:
falsex: -400.000000
falsey: -400.000000
System Units .........: 1000000000.000000
Z Offset..............: 0.000000
Z Units ..............: 1.000000
Measure Offset .......: <None>
Measure Units ........: <None>
XY Cluster Tolerance .: 0.000000008983
Spatial Index ........:
parameter: SPIDX_GRID,GRID0=0.29,FULL
exist: Yes
array form: 0.29,0,0
Layer Envelope .......:
minx: 31.09743, miny: 14.53603
maxx: 55.69328, maxy: 34.39108
Entities .............: nac+
Layer Type ...........: Extended SQL Type/ST_GEOMETRY
Creation Date ........: Wed May 15 09:15:05 2013
I/O Mode .............: NORMAL
Autolocking ..........: Enabled
Precision.............: High
User Privileges ......: SELECT, UPDATE, INSERT, DELETE
Coordinate System ....: GEOGCS["GCS_Ain_el_Abd_1970",DATUM["D_Ain_el_Abd_1970",SPHEROID["International_1924",6378388.0,297.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
Layer Configuration ..: TEST_DEFAULT
Thanks for your time
Abdullah