SQL Performance (MOSC)

MOSC Banner

trace causes a session to run faster than without the trace

edited Dec 7, 2017 1:18PM in SQL Performance (MOSC) 4 commentsAnswered

Hi, We are facing a strange fact about a session running a package

Customer is complaining that one application has high response time – about 3 hours


When we put a 10046 trace in order to find out what´s going on, the response time

drops to just a few minutes. On the other hand, when we remove the trace,

application´s response time increases again.

 

Does anyone have an idea about what could be happening ?

Luiz Rogerio

lrsilvei@produban.com.br

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