Database Tuning (MOSC)

MOSC Banner

Slow database ?

edited Jan 21, 2013 10:07PM in Database Tuning (MOSC) 13 commentsAnswered
We try to pinpoint some problems we had with our application this week.
We use weblogic + oracle db.

15 01 - unitl 16.00 pm things were ok but then suddenly the Application was very slow and the DB Connection Pool if 300 connecitons was exhausted.

Weblogic was showing the health as overloaded and all connection were used.

Now we try to find out if this was because of the slow Database or because of the slowness of the Weblogic (due too intensice CPU usage) and threds kept the connection...?

I have attached two AWR reports from 15.-16 pm and from 16-17 pm (the problamatic timeframe)

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