PROBLEM
SDE users querying SDO_Geometry data owned by a different user may encounter Oracle bugs 4716096 and 5031836. This can cause the spatial index on the SDO_Geometry column to not be used.
For more information consult Oracle documentation on the following:
"5031836 - SECURE VIEW MERGING ON 10.2 PREVENTS DOMAIN INDEX USAGE"
"4716096 - DOMAIN INDEX NOT PERFORMED IN QUERY ON VIEW BY A DIFFERENT USER"
This issue is caused by changes that were made to view security in Oracle 10gR2.
Code:
alter system set optimizer_secure_view_merging = FALSE
Code:
grant merge any view to <the users selecting the data>
Article ID: 000010620
Get help from ArcGIS experts
Download the Esri Support App