Latest Contributions by anthonysanchez

Hello, is the oracle client on your remote server 32 or 64 bit?  Direct connects from arcgis require the 32 bit client since they are 32 bit apps. Anthony ... View more

Hello, my understanding is that using bind variables via arcobjects is not possible since the inside of the cursor is not exposed. I heard that in 10 it is, but you'll need to verify.  Until then you could try setting cursor_sharing to similar or force in the database to reduce hard Parsing due to unbound literals in your SQL. Anthony ... View more

Hello Ivan, The enabling/disabling of row movement is purely an Oracle function separate from geodatabases.  You may get better feedback posting a question about row movement in an Oracle forum. Anthony ... View more

Hello, it appears as if a previous attempt that failed has left that state open.  Try closing your edit session again and retry.  If it still doesn't work, close the state manually. update sde.states set closing_Time=sysdate where state_id=1794237 commit; ... View more

Ok - that probably explains the many queries that aren't using the binds. I would suggest using the IGeodatabaseBridge.GetFeatures() api instead of the IFeatureClass.GetFeature(oid) in a loop. This will run one query with the objectid's needed and improve the performance as well. It will return an IFeatureCursor which can then be used in a loop. FJ - this is great.  By implementing this would the rdbms result be one query with an IN list in the where clause?  If so, performance would be much better from the rdbms perspective. thanks Anthony ... View more

there are a few triggers in the sde schema responsible for maintaining this integrity.  Make sure you have all of them and that they are valid. SQL> select table_name from dba_constraints where constraint_name='GEOM_SRID_FK1'; TABLE_NAME ------------------------------ ST_GEOMETRY_COLUMNS SQL> select owner,name from dba_dependencies where referenced_name='ST_GEOMETRY_COLUMNS' and type='TRIGGER'; OWNER                          NAME ------------------------------ ------------------------------ SDE                            DB_EV_RENAME_ST_METADATA SDE                            DB_EV_ALTER_ST_METADATA SDE                            DB_EV_DROP_ST_METADATA SDE                            TG_ST_GEOMINDEX_NAME SDE                            TG_GCOL_NAME SQL> select * from sde.version;      MAJOR      MINOR     BUGFIX DESCRIPTION      RELEASE SDESVR_REL_LOW ---------- ---------- ---------- ------------------------------------------------------------------------------- --------- ---------- --------------          9          3          0  for Oracle10g Build 546 Thu Sep 18 12:35:50  2008        93003          93001 ... View more

Hello Nathaniel, Altering your oracle init parameter cursor sharing will accomplish this. It can be done at the session level via a login trigger or via arcobjects. Alter session set cursor_sharing=similar; Aside from I noticed that your job gets one row at a time. This will likely be slow even if optimized. I don't know what your process is doing but if the calls can be reduced and commits less frequent it will likely perform better. Anthony ... View more

Hello Martin, is it possible for you to post the raw trace as an attachment? Anthony ... View more

Hello, I'd suggest running a level 12 trace and include waits and binds during your next test. The formatted trace results (tkprof) will tell us if the problem is in the database or on the client. Anthony ... View more

Hello, I'd recommend putting a level 12 trace login trigger for the sde user in place and trying to start the service again. This would tell us the exact SQL and object that are throwing the error. Search for "err=" in the raw tracefile. -anthony ... View more