Database Tuning (MOSC)

MOSC Banner

Time spent not on DB.. but where?

edited Nov 10, 2014 3:18PM in Database Tuning (MOSC) 13 commentsAnswered

Hi Folks

we have a problem in hand for one of our application running 11g R2 database.

One of our application is having performance issues. For example, when we go from one screen to another it takes about 5 minutes.. to complete.. but database level tracing / tkprof / ASH/AWR monitoring indicates there is no problem at the database level and the the elapsed time is only 1 minute for the processing of all queries involved.. We are trying to find out where the rest of the 4 minutes are spent.. i.e, the time not spent on the database server..

The application server is not CPU pegged at all.. Given this scenario, how can we proceed with finding out where the problem is? We suspect and guess that if its not db server and not app server, it has to be network but the question is how to prove that? If we enable sql net level tracing on the application server, would we be able to identify anything?

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center