- Copyright
- Preface
- About the Authors
- Acknowledgments
- We Want to Hear from You!
- Introduction
- Getting Started with Oracle Database 10g
- Exploring Oracle Database 10g Architecture
- Installing Oracle Database 10g
- Installation Decisions
- Prerequisites
- Installing 10g on UNIX/Linux
- Oracle Database 10g DBCA Overview
- Installing 10g on Windows
- Companion CD Installation and Patches (All Platforms)
- Installation Checklists
- Database and Binary Cloning
- Using Enterprise Manager for Cloning
- Migrating a Database from 8i or 9i
- Overview of Database Upgrade Assistant
- Applying Patches to Database Installations
- Uninstalling from a Failed Install
- Summary
- Customizing Installation Options
- Setting Up Automatic Storage Management
- Quick Wins Using Oracle Database 10g
- Tuning Oracle Database 10g
- Scaling and Availability with Oracle Database 10g
- Utilizing Oracle Database 10g Real Applications Clusters
- Oracle 10g RAC Overview
- Cluster Ready Services
- Service Workload Management
- 10g RAC Installation and Migration Enhancements
- 10g RAC Manageability Enhancements
- Automatic Storage Management for Cluster Management
- Third-Party Cluster Management Support
- Limited Rolling Upgrade with OPATCH
- 10g RAC Tips for Better Use
- Advanced RAC Features in Oracle Database 10g Release 2
- Summary
- Utilizing 10g Physical and Logical Standby with Data Guard
- Effectively Using Flashback Technologies
- Leveraging Grid Technology Features
- Utilizing Oracle Database 10g Real Applications Clusters
- Using Oracle Database 10g Utilities and Other Advanced Features
- Maximizing Data Movement with Oracle Data Pump
- Using 10g SQL*Plus and iSQL*Plus
- Making the Most of Oracle Database 10g
- A Collection of Useful Features
- DML/DDL Features
- Network Features
- Security Features
- Resource Manager and Scheduler
- New Database Initialization Parameters
- Oracle Streams Enhancements
- MetaLink Integration with Oracle Database 10g
- Oracle Database 10g EM Patch Cache
- Oracle Applications 11i with Oracle Database 10g
- Summary
- Index
Summary
In this chapter, you saw AWR and ASH in great detail. These two tools can and should be your first line of defense in tracking, viewing, and diagnosing performance issues with an Oracle Database 10g instance. Knowing and understanding the views behind AWR and ASH as well as the SQL and PL/SQL interface to these tools will enable you to get to the root of the problem quickly and efficiently.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.