Database Administration (MOSC)

MOSC Banner

Performance degrade with every consecutive run

Hi

I have the 11.2.0.4 database where my application runs. I initiated few processes and it took certain time. I have initiated the same processes and it took more time. It happened the same way even in the next couple of runs. So the first execution and 4th execution the timings have increased by almost 150%. I truncated the tables and initiated the executions. The timings were normal. Can someone guide me on how to understand this and where to start with analysis. This involves multiple tables and packages called in the process.

Thanks

Ram

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