Spatial (MOSC)

MOSC Banner

MDSYS sql with a huge amount of executions.

in Spatial (MOSC) 2 commentsAnswered

Hello ! We have this sql executing millions of time during a batch window.

Not sure where it originates, talking to our app developers it should not come from the app.

Parsing schema is MDSYS . Tried to find out if this is some kind of internal oracle sql

but cannot find anything. Anyone seen this ? Possibly executed "By us" since module = sql*plus ?

I have tuned and removed the impact, but still curious where it comes from.

STATSPACK report shows.

 Elapsed         Elap per    CPU             Old

 Time (s)  Executions Exec (s) %Total  Time (s) Physical Reads Hash Value

---------- ------------ ---------- ------ ---------- --------------- ----------

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