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.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
DR_BASE = C:\app\oracle\product\12.2.0\dbhome_1\log
DIAG_ADR_ENABLED = OFF
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.