Oracle connections at ArcGIS for Desktop 10.3 and later versions impose the REPLACE function on the TableListTables command, resulting in a negative impact on the performance.
上次发布: October 20, 2016ArcSDE/Enterprise Geodatabase
漏洞 ID 编号
BUG-000095035
已提交
March 16, 2016
上次修改时间
April 27, 2022
适用范围
ArcSDE/Enterprise Geodatabase
找到的版本
10.3.1
服务器平台
N/A
状态
Known Limit
经开发团队审核,已确定此问题与不受 Esri 控制的软件的已知限制有关。 问题的“其他信息”部分可能包含进一步说明。
附加信息
The use of the "REPLACE" function in the TableListTables API is required to
compare OS authenticated user names. OSA user names are enclosed in double-quotes when stored in SDE metadata, but not so in the Oracle data dictionary.
A proper comparison of user names in the join requires the use of the "REPLACE" function in the query. This may not have been implemented correctly at older releases, ex: 10.2.2 - but proper support for ST_GEOMETRY data owned by OSA users was implemented at 10.3.1.
Removing the call is not feasible.