Trace

A users is having a problem with the application such that they cannot go to the next page in the application, they just get the hour glass. When I trace the user's session the problem goes away. It has happened a number of times. Can you think of any correlation here?
msimons4Asked:
Who is Participating?
 
sventhanConnect With a Mentor Commented:
What do you see in V$session when user is waiting? Do you see any locking issues?

Query V$locked_object to see for any issues.
0
 
sventhanConnect With a Mentor Commented:
Also, you can query the following DMVs/Tables

V$transaction
v$lock
v$dba_lock
V$dba_blockers
v$dba_ddl_locks
v$dba_dml_locks
0
 
msimons4Author Commented:
Are these only for active sessions?
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
>>Are these only for active sessions?

Yes.

If the apps 'hourglass' is due to an Oracle issue, it is likely waiting on something.

I'm not convinced that just by 'tracing' the session, it causes the app to magically start working.

Many times: coincidence does not imply causation
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.