8-22 Oracle Application Management Pack for Oracle E-Business Suite Guide
• Form sessions can be monitored only when the site-level profile Sign-On:Audit
Level is set to 'FORM'. The internal name for this profile is
'SIGNONAUDIT:LEVEL'.
Top Sessions
This page will show four bar charts of database sessions triggered by APPS database
user.
• Top waiting sessions: sessions waiting for a database event to trigger to proceed
further.
• Top running SQL statements.
• Top CPU consuming sessions.
• Top memory intense sessions.
The level of detail shown in the bar graphs is controlled by properties set in the
Preferences page. See: Setting Preferences, page 6-1.
• Sampling Interval for User Monitoring. By default it is 15 minutes and can be
increased up to 60 minutes.
• Number of Rows in tables of User Monitoring.
You can drill down from the legend to see the details of the session. If the Oracle
E-Business Suite user information is available, the Oracle E-Business Suite session
details is shown with further drilling down available to the database session details. If
the Oracle E-Business Suite user information is not available (that is, the database
sessions was triggered by a background process and not by a user), you can drill down
to the database session details directly.
To navigate to the Top Sessions page, select User Monitoring > Top Sessions from the
target menu of the Oracle E-Business Suite target.
Kommentare zu diesen Handbüchern