This page can be used to review the performance of a database component for a specific request. The specific request is listed in the request field just below the page title.
Use the Request Processing Time and Load chart to investigate the impact of database server activity on the request response time. Note the number of hits versus the time spent processing each of the database subsystem components. You can use this data to identify trends or to isolate periods when performance was less than optimal over the past 24 hours, 7 days, or 31 days.
Use the Processing Time Breakdown chart to analyze the middle tier at the subcomponent level. This allows you to make informed and accurate decisions in order to tune or repair the appropriate elements of a Web application.
Analyze each subsystem component further by drilling down on either the Processing Time Per Hit or Database Time links.
To gain more insight into the performance of your middle-tier components, consider these tips:
To correlate the middle-tier processing time and load data with other application performance data, such as resource utilization, response, load, target availability, and other component metrics, click Correlate Performance.
To view the entire request processing call stack, including the relationship and order of the components called by this request, click Processing Call Stack.
Related Topics
About Web Application Management
About Monitoring Middle Tier Performance
Reviewing the Slowest Web Application Requests
Viewing Middle-Tier Performance Data
Correlating Middle-Tier Request Performance
Viewing the Entire Middle-Tier Call Stack for a Request
Enterprise Manager Information Roadmap
Copyright © 1996, 2007, Oracle. All rights reserved.