Database management involves the monitoring, administration, and maintenance of the databases and database groups in your enterprise.Enterprise Manager is the premier tool for managing your database environment.With Enterprise Manager, you receive: Starting from the Database Home page, you can access additional details and management functions by drilling down through the user interface.
From these links you can perform activities such as editing metric thresholds, analyzing job activity and metric collection errors, and accessing a number of advisors to help you improve the performance of your database.
Comprehensive database monitoring enables you to identify the problem areas in your database environment that are degrading performance.
After you have identified the areas to improve, you can tune your databases' performance using the Enterprise Manager administration capabilities.
Enterprise Manager uses data from the Automatic Workload Repository (AWR) to display performance information and initiate database alerts.
Database tuning is much easier and more effective when all the information for an in-depth performance diagnosis is available on a single screen.
On the Database Performance page (Figure 5-2), which is accessible from the Database Home page, you can quickly view performance data for the instance and its underlying host.
Additionally, you can analyze trends for all critical performance metrics and compare the trends to those of other database instances.
The user interface provides several real-time performance charts and drill-downs for the targets you manage.
Both aggregate and instance-specific performance statistics are displayed using color-coded charts for easier viewing.