Diagnostics and Analysis White Papers
Response-Time Analysis Made Easy in Oracle Database 10g
Overview Historically, in trying to achieve maximum database performance, Oracle DBAs and performance analysts have fought an uphill battle to obtain solid response time metrics for system as well as user session activity. The problem facing DBAs has always had two facets: first, determining exactly "Where" the database or user sessions have been spending their time; and second, determining the objective nature of the user experience. Fortunately, those Oracle DBAs who have upgraded to Oracle Database 10g will find major response-time enhancements that allow a much better picture to be presented about system and session-level response-time metrics. This paper will explore the use of some of the historical mechanisms at the system, session, and SQL levels.
| Publisher | Oracle | File Format | HTML |
|---|---|---|---|
| Date Published | October 2006 | ||
| Format | White Papers | ||
| Topics | |||



