Database Tuning (MOSC)

MOSC Banner

ASH report - Wait event

edited May 29, 2012 8:14PM in Database Tuning (MOSC) 6 commentsAnswered
Hi,

I have a DB running on 11.2.0.2, recently there is performance problem reported on one of the application job, during the job run time, I can see lots of time the job's session has wait SQL*Net message from client, looks like lots of time the DB is doing nothing while waiting for the application server next instruction to proceed, when i tried to review the ASH report, generating past report for this session, I can't see this wait event reported.

Anyway I can check if the session has SQL*Net message from client in the past, I used ASH report but this wait event is not reported but I'm pretty sure this is the cause why the job is slow.

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