Latest Contributions by anthonysanchez

Hello Elizabeth, I have an idea assuming you are not using st_geometry. install the oracle client on your pc.  Then install the sde binaries + patch you require.  Do the upgrade remotely.  Afterwards you can just use direct connect to your db server or if you really want a service, run the service remotely from another machine (not recommended). Anthony ... View more

Hello Fabian, You'll get better feedback if you post some more details: 1) exact error message 2) your pl/sql that is throwing the error 3) full oracle and arcsde version 4) any relevant details about the data you are processing 5) other logs, etc, etc. good luck, Anthony ... View more

TJ, you may also want to view this thread: http://forums.arcgis.com/threads/1948-Oracle-amp-ST_GEOMETRY-slow-performance?highlight=st_geometry+slow ... View more

Thanks Vishal. I tried again using the method recommended above and got the same exact errors as before. Also, one of the errors listed in the KB is not the same as the one I'm getting. I get the first two it lists, but I don't get: ORA-39779: type "SDE"."ST_GEOMFROMTEXT" not found or conversion to latest version is not possible". Instead, I get the following (note the different function): ORA-00600: internal error code, arguments: [kpudpxcs_ctxConvertStream_ref_1], [SYS_TYPEID("SHAPE")], [], [], [], [], [], [], [], [], [], [] So there is something different going on. What do you advise? Hello, ST_GEOMETRY is a user defined type.  There are many dependencies and public synonyms, many of which will not come across in a schema level dp export.  I'd suggest taking a FULL data pump export and importing into your test system. ... View more

Hi TJ. Do you have a raw level 12 trace file that captures the problem that includes #stat lines (rowsource operations) for the SQL?  If so can you attach to this thread? The stat lines in addition to waits and binds are very important. If you don't have stat lines and are using 10g, you'll need to  reproduce and close out of arcmap completely to close the cursors and stop the trace vs stopping the trace manually in the database. -anthony ... View more

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