Database Administration (MOSC)

MOSC Banner

Selecting ALL_SDO_GEOM_METADATA extremly slow

edited Sep 29, 2015 10:01AM in Database Administration (MOSC) 1 commentAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center