PL/SQL (MOSC)

MOSC Banner

dbms_pickler.get_type_shape executed from SOA server to EBS DB creates latent high load

edited Apr 16, 2020 5:00AM in PL/SQL (MOSC) 3 commentsAnswered
Whenever our SOA server is running, the following can be seen running at steady high load on our EBS database.  Shutting down SOA causes it to go away.  Is there a way to determine whether this is a bug, known issue, or just a poorly-profiled piece of code?
Current SQL statement:
Previous SQL statement:
        begin :1 := dbms_pickler.get_type_shape(:2,:3,:4,:5,:6,:7); end;


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