Database Tuning (MOSC)

MOSC Banner

Package execution time increases with time

edited Mar 24, 2015 10:02AM in Database Tuning (MOSC) 10 commentsAnswered

There is a package in our production database whose performance (execution time) degrades over time. Please find below details of execution time as time goes on:

Oracle Database Version: 11.2.0.2.0

Platform: Solaris 5.10

No. of Hours after Application is started     Average Execution Elapsed Time (seconds)          No. of Executions

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

1                                                          1.6                                                                           1096

2                                                           2.6                                                                          1019

3                                                           3.2                                                                           995                 

4                                                           3.1                                                                           1074

5                                                           4.1                                                                           1035

6                                                           6.7                                                                           741

7                                                           7.5                                                                           823   

8                                                           5.5                                                                           716

9                                                           8.9                                                                           549

10                                                         8.4                                                                           914

The general trend is that execution time continues to increase until we restart the Weblogic Application that executes this package; and then the cycle is repeated again.

Weblogic Version: 10.3.2

Could this be caused by a Bug or an insufficient/inappropriate Database setting?

I need help please.

Thanks                               

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