Knowledge and Data Management White Papers
Historical Performance Analysis Using AWR
Overview The Automatic Workload Repository (AWR) in Oracle Database 10g and 11g stores a wealth of data regarding database performance. This data is a key component of the Diagnostics and Tuning pack and is licensed as part of the Diagnostics Pack. Oracle Enterprise Manager provides a graphical user interface to this data, allowing one to display and diagnose the performance of one's database. The standard AWR report offers an alternate view into these statistics, by providing detailed information for a specified time interval. There are times when viewing longer term historical information would be useful. Viewing this longer term historical information could help pinpoint when a performance problem may have started. Was the onset sudden, or did the workload gradually increase over a few weeks?
| Publisher | Oracle | File Format | |
|---|---|---|---|
| Date Published | April 2009 | ||
| Format | White Papers | ||
| Topics | |||
-
Did you find this white paper useful? 3 out of 3 users found this white paper useful
White Paper RSSAccelerating Enterprise Data Governance Part 1
DownloadIn the first of this series of three white papers, Mike Ferguson of Intelligent Business Strategies defines what data governance is and then looks at the requirements that need to...
Data Governance for Master Data Management and Beyond
There is growing interest on behalf of both data management professionals and senior business managers to understand the motivations, mechanics, and benefits of instituting data governance within an organization. This...
Getting Started with Master Data Management
Master data management forms part of an overall enterprise governance program that aims to establish trusted data throughout the enterprise. This white paper from Mike Ferguson of Intelligent Business Strategies...
Five Steps to More Valuable Enterprise Data
Companies worldwide struggle with inconsistent, inaccurate or unreliable data - and often don't know how to build more useful corporate information. This white paper examines a five-step method for...
The Evolution of Integration
Once upon a time life and information systems were simple. Then one day somebody let Pandora out of her box. Someone said -can't we add new requirements to these systems?...
