AnsweredAssumed Answered

How to isolate and fix Enterprise Geodatabase speed issues with ArcGIS Pro

Question asked by DCENR on May 15, 2020
Latest reply on May 18, 2020 by jonnyha

Hi, 

 

I wonder if anybody has time to throw out a few ideas or knowledge snippets to help please? My issue is with an Oracle Enterprise Geodatabase (10.7.1 on Oracle 12) and Arcgis Pro 2.5 (and ArcMap).  The rough overview : I have a feature class of 990,000 records with 10 attributes and I want to update one attribute for all rows using field calculate in  Pro using direct connect to a non versioned feature class.  The calculate is just - update a column to a value such as 110.  

This is simplified for testing purposes.  My initial timings for this calculate is 18-20 minutes, post investigations we discovered symantec antivirus did not have exceptions for Oracle on the database server, once that was sorted the query updates in 10 mins 15 seconds, so a huge improvement but still way to slow.  For this test case my desktop was communicating across the network to perform this query/update, so we used wireshark  to see if there where packets or connections causing issues etc. (apologies I'm not a networking guy!) but apparently the network is fine, they also used cross over cables to test and take the actual network out of the equation but the times returned are roughly the same.  For sanity sake I installed Pro on the database server and ran the query locally - and it completes in 3 mins flat - a full 7 minutes faster.  

 

The DBA has edited the sqlnet.ora  as below to see if the network traffic can be addressed to reduce it .. but its had no effect so far ....

 

# sqlnet.ora Network Configuration File: E:\app\oracle\product\12.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NONE)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

DR_BASE = C:\app\oracle\product\12.2.0\dbhome_1\log
SQLNET.INBOUND_CONNECT_TIMEOUT=180
DIAG_ADR_ENABLED = OFF
Send_buf_size=65536
recv_buf_size=65536
default_sdu_size=65535

 

 

So can anybody recommend and approach to isolate the issue, as it only arises when i introduce the network into the equation , can anybody spot something glaringly obvious that I'm missing.  Is it possibly something in ArcGIS Pro that can be configured? Any thought observations or direction would be hugely appreciated.  

 

 

Cheers

 

Paulg

Outcomes