Selecting ALL_SDO_GEOM_METADATA extremly slow
Hello,
if I try to get all for me accessible geometry columns using the view "ALL_SDO_GEOM_METADATA"
it takes more than 20s to retrieve some rows.
(Some rows means five in my case).
The attached execution plan looks not very easy for me to understand, what goes wrong. As far
I can see that the problems comes from ALL_OBJECTS view.
I'am running Oracle 12c (12.1.0.2.0 + Patch Bundle 7 ) on Windows 2008 Server.
Until now I tried to update Stats. (running sys/sys as sysdba)
exec DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
exec DBMS_STATS.GATHER_DICTIONARY_STATS;
but nothing fixed the issue.