Latest Contributions by User35489

Hi, Any updates to share, buddy ? Thanks Have raised a Support query with ESRI re this matter. I will post response/resolution when found. ... View more

I can't think of a single reason why that command should ever be run as user SDE. The SDE user should be reserved for ArcSDE instance administration.  The SDE user should not ever own spatial data (treat it like a restricted admin account). - V I too agree with you, Vince... Actually the command is run by the SDE User, but the layer is owned by another user. It was just to show the example. Actual command looks like this $ sdelayer -o describe_long -i 5151 -l LayerOwner.LayerName,ColumnName -u sde -s ServerName Thanks for your inputs. Regards -AS ... View more

Vince thanks for your input.. While trying to find a workaround, i found the below command worked instead.. sdelayer -o describe_long -i 5151 -l LayerName,Column -u sde -s ServerName I found the below link to find a workaround... http://forums.arcgis.com/threads/2309-A-problem-seemed-silly-cannot-connect-to-SDE-service Thanks to "Yu De" -AS ... View more

Just heard back from ESRI support and they are experiencing the same issue with the data I sent them. I will post findings. Hi, Is there any update for the above issue.... ? Thanks for sharing -AS ... View more

So your subject line is a non-sequitur, because the spatial index is never used in  a full-extent query.  In fact, if you forced a full-extent query to use the spatial index, it would be much slower. All you're seeing is the difference between a LONG RAW query and a LOB query. Oracle deprecated LONG RAW use more than a decade ago, and it fails frequently at some sites, so you really shouldn't be using it. You can gain some of that perfromance back by proactively managing your coordinate reference parameters -- Instead of defaulting to the -400,-400,1billion XY offsets and scale, try using -400,-400,1million.  Lopping off those extra digits will cut the storage requirements (at the cost of going from sub-millimeter to sub-decimeter precision). - V Great tip vince, I tried with -400, -400, 1 million. it drastically changed the access speed. Your inputs are really benificial. Do you suggest any more changes ? With Best Regards, -AS ... View more

are the geomtery storage identical in both layers ? It differs, 9.3 has SDEBINARY and 10.1 has ST_GEOMETRY. -AS ... View more

7 vs 17 seconds to do what?  Draw the entire layer? - V It takes 7 seconds in 9.3 to draw entire layer and takes 17 seconds in 10.1. I tried analyse, rebuilding Spatial indexes etc. It did not worked out. -AS ... View more

Good Day, Removing SDE Administrator account and recreating it, fixed the problem. Thanks all for support. With Best Regards -Abdullah ... View more

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 ... View more

Did you just change it in the file, or did you change it in the file then use 'sdedbtune' to update it in the SDE.DBTUNE table? Please mark FJ's answer as the solution. - V Hi Angelo, I exported dbtune, made changes and imported it back.. I think the issue is with SQL Developer, when i view the details for tables, it shows null in Tablespace. But just now when i viewd properties by selecting EDIT it showed me the correct tablespace. Any ways the answer given be FOJO helped me to correct the mistake of quote placement. Thanks FOJO, Vince Regards ... View more

Hi FOJO, Thanks for your input, I tried making changes you highlighted. Still the index created goes in "So called 'Null' as viewed by SQL Developer" Tablespace Any more ideas ? Dudes . . -AS ... View more