Databases Reference
In-Depth Information
On the Enterprise Manager front page the
Active
Sessions
graph can be seen. When
looking at the performance tab, you will see that there are several sessions waiting
and also what the session is waiting for. Here, the
Application
event is the most
common outstanding event in the system. A lot of waits due to the
Application
event means that the currently running applications leave their sessions on the lock
enqueue mechanism.
Clicking on the
Top
Activity
link, will take the DBA to the processes details page.
The reason why the system is slow is that there are several sessions waiting for the
same row to be freed. The sessions may remain waiting there forever.
Search WWH ::
Custom Search