Latest Contributions by MatjazHabic

‎05-19-2022

This is possible workaround, where we can’t use Drag&Drop from Catalog pane. If I add layer via Make Query Layer and provide all necessary data, process completes within 2 seconds. Matjaž

‎05-19-2022

Hi, the table is just a spatial table in Oracle. I understand that full table scan (FTS) last so long, but it is not necessary to get max extent from database, if I enter this coordinates in input form My opinion is that this input form is made for this type of situations to avoid long lasting FTS. Performance (zoom,pan) after initial layer adding is ok. Matjaž

‎05-19-2022

When we add Layer from Oracle 19c (SDO_GEOM geometry), there is dialog for calculating extent. If we chose first or second option, it takes over 30 minutes for application to respond. If we check sessions on database there is following select with full table scan which can't be terminated. Sum of elapsed time and remaining time is over 1700 seconds. SELECT SDO_AGGR_MBR (GEOM) FROM CGIS_WEBGIS.ZKN_GR x WHERE x.GEOM.SDO_GTYPE IS NOT NULL If we manualy enter Extent for that layer, why application still run this sql statement ? Table has over 5Mio polygon records. We have Oracle 19C and Arcgis Pro 2.9.3.

‎07-30-2015

After upgrade from ArcSDE 9.2 (Oracle 10.2 g) to ArcSDE 10.2.2 (Oracle 12c) there was problem by ST_GEOMETRY spatial index export with datapump. This script resolves the problem. Thanks Tracie Matjaz

‎01-21-2014

Hi I also encountered this bug on Linux (RedHat) and Windows on version ArcSDE 10.1 SP1. As temporary alternate solution (I expected patch on 10.1 ) I use library from version 10.0 SP5. On version 9.2 sp 5 (IBM AIX and Windows) there is no problem with very large strings (over 350000 characters). Regards Matjaz This workaround produce new problem. Now sde.st_interiorringn function produce this error, ORA-28579: network error during callback from external procedure agent ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 325 ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 1914 We tried to install new library (10.2.1) but the same problem with st_interiorringn occurs. Testcase for st_interiorringn error on library (libst_shapelib.so) version 10.0 SP5 set serveroutput on; declare wkt clob := 'POLYGON (( 7589076.32000000 4639013.97000000, 7589053.44000000 4638981.25000000, 7589036.37000000 4638960.17000000, 7589029.93000000 4638891.70000000, 7588997.08000000 4638895.02000000, 7588995.90000000 4638882.02000000, 7588980.43000000 4638851.96000000, 7588982.13000000 4638825.12000000, 7588953.53000000 4638800.16000000, 7588940.44000000 4638757.77000000, 7588922.39000000 4638773.94000000, 7588903.00000000 4638759.04000000, 7588901.46000000 4638747.12000000, 7588909.22000000 4638746.86000000, 7588918.95000000 4638703.71000000, 7588914.68000000 4638682.78000000, 7588922.18000000 4638644.07000000, 7588929.20000000 4638607.70000000, 7588935.01000000 4638595.19000000, 7588934.37000000 4638592.15000000, 7588971.30000000 4638582.34000000, 7588999.41000000 4638573.30000000, 7589008.40000000 4638567.38000000, 7589037.75000000 4638543.79000000, 7589064.70000000 4638521.16000000, 7589089.94000000 4638503.03000000, 7589102.48000000 4638495.91000000, 7589116.68000000 4638492.84000000, 7589136.88000000 4638489.28000000, 7589164.91000000 4638484.37000000, 7589215.03000000 4638460.31000000, 7589226.42000000 4638457.63000000, 7589248.26000000 4638449.10000000, 7589264.00000000 4638437.64000000, 7589277.44000000 4638422.20000000, 7589291.81000000 4638399.27000000, 7589268.88000000 4638377.52000000, 7589250.43000000 4638360.55000000, 7589257.21000000 4638338.63000000, 7589259.27000000 4638331.30000000, 7589278.38000000 4638287.11000000, 7589291.19000000 4638267.75000000, 7589301.22000000 4638248.88000000, 7589325.26000000 4638218.81000000, 7589373.09000000 4638258.92000000, 7589384.57000000 4638270.05000000, 7589405.45000000 4638241.14000000, 7589438.24000000 4638194.01000000, 7589433.03000000 4638182.31000000, 7589437.00000000 4638175.51000000, 7589452.26000000 4638196.43000000, 7589464.63000000 4638180.98000000, 7589484.09000000 4638140.65000000, 7589488.85000000 4638125.49000000, 7589492.48000000 4638115.51000000, 7589499.08000000 4638106.11000000, 7589502.05000000 4638066.76000000, 7589501.89000000 4638049.39000000, 7589499.11000000 4638033.69000000, 7589523.88000000 4638029.38000000, 7589542.03000000 4638030.12000000, 7589580.38000000 4638039.36000000, 7589618.61000000 4638050.63000000, 7589656.33000000 4638061.05000000,'|| ' 7589666.59000000 4638065.03000000, 7589702.05000000 4638075.07000000, 7589762.58000000 4638098.22000000, 7589789.08000000 4638111.09000000, 7589803.99000000 4638120.17000000, 7589813.56000000 4638123.60000000, 7589850.45000000 4638137.14000000, 7589896.89000000 4638148.10000000, 7589900.41000000 4638158.75000000, 7589902.36000000 4638184.90000000, 7589909.90000000 4638242.35000000, 7589909.54000000 4638280.87000000, 7589908.26000000 4638311.16000000, 7589907.27000000 4638326.30000000, 7589902.94000000 4638343.29000000, 7589898.17000000 4638350.92000000, 7589893.09000000 4638345.60000000, 7589873.38000000 4638332.32000000, 7589869.97000000 4638331.79000000, 7589857.02000000 4638359.91000000, 7589842.88000000 4638354.25000000, 7589820.55000000 4638397.16000000, 7589815.26000000 4638398.74000000, 7589806.33000000 4638419.24000000, 7589792.76000000 4638445.96000000, 7589789.98000000 4638451.31000000, 7589770.51000000 4638481.64000000, 7589751.04000000 4638502.50000000, 7589744.39000000 4638497.62000000, 7589737.78000000 4638492.14000000, 7589748.40000000 4638476.42000000, 7589758.47000000 4638461.79000000, 7589767.14000000 4638445.17000000, 7589773.98000000 4638435.48000000, 7589780.25000000 4638423.92000000, 7589786.38000000 4638405.96000000, 7589795.19000000 4638384.18000000, 7589782.31000000 4638381.87000000, 7589795.86000000 4638343.41000000, 7589811.11000000 4638302.32000000, 7589830.14000000 4638253.52000000, 7589830.53000000 4638243.62000000, 7589828.87000000 4638236.22000000, 7589826.70000000 4638231.38000000, 7589823.13000000 4638223.25000000, 7589813.37000000 4638204.43000000, 7589800.28000000 4638202.11000000, 7589784.24000000 4638199.94000000, 7589782.44000000 4638201.00000000, 7589773.06000000 4638198.15000000, 7589768.48000000 4638197.53000000, 7589750.32000000 4638190.40000000, 7589746.23000000 4638225.98000000, 7589739.65000000 4638250.36000000, 7589730.86000000 4638276.84000000, 7589716.14000000 4638306.16000000, 7589698.39000000 4638335.72000000, 7589674.87000000 4638369.26000000, 7589651.24000000 4638403.48000000, 7589671.02000000 4638424.36000000, 7589699.55000000 4638402.20000000, 7589730.33000000 4638361.29000000, 7589744.21000000 4638369.42000000, 7589750.18000000 4638374.59000000,'|| ' 7589763.47000000 4638376.85000000, 7589765.97000000 4638377.47000000, 7589759.35000000 4638401.85000000, 7589751.61000000 4638418.20000000, 7589736.64000000 4638446.70000000, 7589714.18000000 4638473.29000000, 7589678.48000000 4638500.28000000, 7589670.69000000 4638496.74000000, 7589643.24000000 4638520.82000000, 7589610.24000000 4638545.05000000, 7589570.66000000 4638571.76000000, 7589563.58000000 4638583.85000000, 7589560.40000000 4638584.13000000, 7589565.15000000 4638592.63000000, 7589552.39000000 4638581.26000000, 7589529.86000000 4638562.90000000, 7589522.57000000 4638559.29000000, 7589506.37000000 4638550.51000000, 7589494.28000000 4638565.06000000, 7589485.95000000 4638584.27000000, 7589533.64000000 4638614.64000000, 7589557.42000000 4638637.71000000, 7589570.94000000 4638623.25000000, 7589582.93000000 4638607.58000000, 7589607.46000000 4638622.27000000, 7589634.53000000 4638641.92000000, 7589627.05000000 4638653.16000000, 7589608.36000000 4638680.74000000, 7589647.38000000 4638699.24000000, 7589687.41000000 4638722.69000000, 7589660.92000000 4638755.38000000, 7589637.99000000 4638768.57000000, 7589621.16000000 4638773.54000000, 7589609.73000000 4638771.42000000, 7589608.95000000 4638784.95000000, 7589619.01000000 4638789.05000000, 7589655.37000000 4638780.51000000, 7589670.21000000 4638773.07000000, 7589684.62000000 4638762.41000000, 7589711.90000000 4638732.75000000, 7589738.35000000 4638703.21000000, 7589756.00000000 4638707.67000000, 7589764.77000000 4638711.06000000, 7589783.96000000 4638727.52000000, 7589805.35000000 4638736.50000000, 7589801.46000000 4638741.15000000, 7589769.16000000 4638776.32000000, 7589743.84000000 4638802.29000000, 7589730.79000000 4638810.15000000, 7589703.99000000 4638811.08000000, 7589686.91000000 4638808.44000000, 7589654.12000000 4638801.55000000, 7589640.58000000 4638799.92000000, 7589640.48000000 4638800.98000000, 7589621.88000000 4638798.95000000, 7589590.60000000 4638801.96000000, 7589552.93000000 4638806.13000000, 7589520.24000000 4638802.73000000, 7589495.06000000 4638801.05000000, 7589472.86000000 4638789.91000000, 7589454.29000000 4638784.71000000, 7589408.74000000 4638797.32000000, 7589368.15000000 4638808.44000000, 7589317.65000000 4638821.44000000,'|| ' 7589284.27000000 4638827.51000000, 7589273.80000000 4638829.80000000, 7589228.57000000 4638841.69000000, 7589198.92000000 4638861.92000000, 7589158.21000000 4638897.77000000, 7589121.45000000 4638934.52000000, 7589097.74000000 4638964.37000000, 7589089.98000000 4638980.99000000, 7589080.88000000 4639003.42000000, 7589076.32000000 4639013.97000000),( 7589571.88000000 4638334.27000000, 7589590.12000000 4638358.15000000, 7589628.46000000 4638291.07000000, 7589663.80000000 4638213.62000000, 7589673.69000000 4638166.93000000, 7589653.87000000 4638162.45000000, 7589648.99000000 4638160.76000000, 7589639.50000000 4638199.20000000, 7589629.84000000 4638225.48000000, 7589606.42000000 4638273.79000000, 7589571.88000000 4638334.27000000),( 7589500.48000000 4638362.59000000, 7589505.53000000 4638382.09000000, 7589582.90000000 4638356.21000000, 7589572.23000000 4638340.20000000, 7589562.89000000 4638343.34000000, 7589500.48000000 4638362.59000000),( 7589507.61000000 4638169.42000000, 7589503.16000000 4638184.65000000, 7589498.35000000 4638194.38000000, 7589484.81000000 4638214.73000000, 7589476.18000000 4638224.82000000, 7589482.52000000 4638231.56000000, 7589502.41000000 4638210.07000000, 7589510.38000000 4638188.87000000, 7589511.74000000 4638175.26000000, 7589521.67000000 4638148.66000000, 7589527.61000000 4638115.46000000, 7589519.24000000 4638113.90000000, 7589513.90000000 4638113.67000000, 7589510.38000000 4638125.46000000, 7589508.16000000 4638136.60000000, 7589506.31000000 4638147.43000000, 7589511.37000000 4638156.40000000, 7589507.61000000 4638169.42000000),( 7589486.85000000 4638385.47000000, 7589501.75000000 4638382.78000000, 7589495.50000000 4638360.74000000, 7589482.05000000 4638362.00000000, 7589486.85000000 4638385.47000000))'; num_rings number; geom1 sde.st_geometry; begin select sde.st_geomfromtext(wkt, 0) into geom1 from dual; select sde.st_numinteriorring(sde.st_geomfromtext(wkt, 0)) into num_rings from dual; dbms_output.put_line(num_rings); select sde.st_interiorringn(sde.st_geomfromtext(wkt, 0),1) into geom1 from dual; end;

‎11-26-2013

Hi I also encountered this bug on Linux (RedHat) and Windows on version ArcSDE 10.1 SP1. As temporary alternate solution (I expected patch on 10.1 ) I use library from version 10.0 SP5. On version 9.2 sp 5 (IBM AIX and Windows) there is no problem with very large strings (over 350000 characters). Regards Matjaz

‎06-12-2013

We have following configuration Oracle on RHEL linux: **********************ArcSDE install summary:********************** ArcSDE 10.1 Oracle_11g (64-bit) Install Location: /home/sde/sdeexe101 Service Pack / Patch / Hot Fix Found: SP-ID: ArcSDE 10.1 Service Pack 1 $ uname -a Linux xxxxxx 2.6.18-274.el5 #1 SMP Fri Jul 8 17:36:59 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux As described in "NIM084235 - St_Geometry spatial indexes are not creating S###$_IX2 indexes on the IOT SP_ID column" for "ArcGIS 10.1 SP1 for (Desktop, Engine, Server) PostgreSQL and Parcel Editing Performance Patch" (http://support.esri.com/en/downloads/patches-servicepacks/view/productid/66/metaid/1941) there is missing index on SP_ID column. Where can be found patch for Oracle ? regards Matjaz

‎04-23-2012

Is there any plan to resolve this issue ? Matjaž

‎02-21-2012

Hi I have the same error »ORA-28595: Extproc-agent: invalid DLL-path« on my win 7 Oracle 11.2. The problem was missing entry ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0) in tnsnames.ora where KEY must be the same in listener.ora and tnsnames.ora. When I restart Listener i have to kill extproc process otherwise restarting doesn't help. Matjaz

‎11-17-2011

I have following example: Two simple polygons touch in single point. I do st_union of this two polygons and then st_difference with third polygon which is bigger than union of first two polygons. Result is not valid geometry and st_astext fails. This example fails on versions: ArcSDE 9.2 sp6, 9.3.1 and 10 (Oracle 10gR2/Windows 2003 and 11g/Windows 2008/64 bit) ArcSDE 9.2 sp6 (Oracle 10gR2/IBM Aix 5.3 /64 bit) Is this bug in SDE.ST_GEOMETRY_SHAPELIB_PKG package. select sde.st_astext(geomdif) from ( select sde.st_difference (c.geom , zs.st_geom) geomdif from ( select sde.st_union (a.geom , b.geom ) st_geom from (select sde.st_geometry('POLYGON (( 1 1, 2 1, 2 2, 1 2,1 1))',1) geom from dual) a, (select sde.st_geometry('POLYGON(( 3 2,3 3,2 3, 2 2,3 2))',1) geom from dual ) b ) zs , (select sde.st_geometry ('POLYGON (( 0 0, 4 0 , 4 4, 0 4 , 0 0 ))',1) geom from dual ) c ) ORA-28579: network error during callback from external procedure agent ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 70 ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 68 Matjaž

‎06-21-2011

Hi Vince thank You for Your quick response. Here are some answers. Character sets are identical: AL32UTF8 I run query locally on each server. Benchmark duration is measured by oracle (set timing on;) and result is show as bellow: on Windows: PL/SQL procedure successfully completed. Elapsed: 00:00:02.84 SQL> / on AIX: PL/SQL procedure successfully completed. Elapsed: 00:00:05.01 SQL> / I think this is not memory related problem. I observe high numbers in "HS message to agent" wait event in Oracle and I think it is related with calling external procedures (st_shapelib.dll and libst_shapelib_64.so). regards Matjaz

‎06-20-2011

I made simple test to measure execution speed of ArcSDE ST_xxx functions on different platforms. The winner in this test is small noname windows server which is twice faster than AIX server. Procedure execution time on Windows is 2 seconds on AIX 4 seconds. Windows environment is twice faster. Is there any explanation for this behavior ? Test script set timing on; DECLARE counter INTEGER := 2; pov number; BEGIN FOR counter IN 1..1500 LOOP SELECT sde.st_area(sde.st_geometry ('POLYGON (( 411008.71460000 4882616.50360000, 411005.20060000 4882619.67950000, 411003.73240000 4882621.00760000, 411000.85260000 4882625.33210000, 410995.91110000 4882618.18640000, 410989.01930000 4882611.21530000, 410977.44560000 4882595.75050000, 410962.63320000 4882575.95560000, 410970.59060000 4882567.36640000, 411005.47230000 4882604.73780000, 411010.73030000 4882608.94600000, 411013.15940000 4882612.48560000, 411008.71460000 4882616.50360000))',5)) into pov from dual; END LOOP; END; / Here are configurations of both environments: Development environment windows 2003 server 32 bit (intel core 2 QUAD @6600@2.4GHz) Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 ArcSDE Version 9.2 ArcSDE Server Build for Oracle10g Build 1206 Listener.ora SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\oracle\product\10.2.0\db_1) (PROGRAM = extproc)(ENVS="EXTPROC_DLLS=ONLY:C:\arcgis\ArcSDE\ora10gexe\bin\st_shapelib.dll") Test environment IBM Power 6, 4 CPU 4,2 GHz 64 bit , aix 5.3.9 Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 64 bit ArcSDE Version 9.2 ArcSDE Server Build for Oracle10g Build 1271 Listener.ora SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /opt/oracle/app/oracle/product/10g/Db_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=/opt/oracle/app/oracle/product/10g/Db_1/lib/libst_shapelib_64.so") ) )

Online Status	Offline
Date Last Visited	‎03-07-2023 06:16 PM

My Ideas

Latest Contributions by MatjazHabic

Re: add layer to Map from Oracle 19C Spatial (SDO_GEOMETRY) is very slow on big tables

Re: add layer to Map from Oracle 19C Spatial (SDO_GEOMETRY) is very slow on big tables

add layer to Map from Oracle 19C Spatial (SDO_GEOMETRY) is very slow on big tables

Re: Oracle data pump import of ArcSDE 9.3.1 ST_GEOMETRY tables fails (10g to 11g)

Re: ORA-20004 Exception when inserting shape to database using st_geometry

Re: ORA-20004 Exception when inserting shape to database using st_geometry

St_Geometry spatial indexes are not creating S###$_IX2

Re: ST_GEOMETRY errors in PL / SQL

Re: Configure ST_Geometry functions in Oracle

Re: ST_GEOMETRY errors in PL / SQL

Re: ArcSDE ST_Geometry functions slow on AIX server in compare to windows server

ArcSDE ST_Geometry functions slow on AIX server in compare to windows server