1 / 44

Common Managed Targets: Database

Common Managed Targets: Database. Objectives. After completing this lesson, you should be able to: Discuss Grid Control’s advantage over Database Control Explain how Grid Control can be used to manage databases

jalila
Download Presentation

Common Managed Targets: Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Common Managed Targets: Database

  2. Objectives • After completing this lesson, you should be able to: • Discuss Grid Control’s advantage over Database Control • Explain how Grid Control can be used to manage databases • Explain how Grid Control can manage older database versions (Oracle 8i and Oracle 9i) • Describe the Database Performance Monitoring features of Grid Control • Describe the Database Administration features of Grid Control • Describe the Database Maintenance features of Grid Control

  3. Ways to Manage Your Database Grid Control Database Control Management Repository

  4. Grid Control Versus Database Control Feature Grid Control Database Control Installation Separate DB 10g Management Repository Centralized In local DB 10g Management Agent One per host in separate home One per DB 10g Home Target Type Many Single DB 10g Number of DBs Many One EM job System Yes Yes Cluster DB (RAC) Yes Yes

  5. Grid Control Versus Database Control Feature Grid Control Database Control Config. mgmt. Enterprisewide Local system Data Guard (Standby DB) Yes No

  6. Accessing Grid Control Versus Database Control • Access to Enterprise Manager is different depending on whether you use Grid Control or Database Control. • Example: DB Host Grid Control URL Database Control URL dbhost1 http://<oms host>:7777/em http://dbhost1:1158/em dbhost2 http://<oms host>:7777/em http://dbhost2:1158/em dbhost3 http://<oms host>:7777/em http://dbhost3:1158/em http://dbhost3:1159/em

  7. Database Home

  8. Managing Databases • With Grid Control, you can manage your databases by exception. • Alerts notify you about problems before users are affected. • Metric histories enable you to identify performance trends.

  9. Managing Oracle 8iand Oracle 9i Databases • You can use Grid Control to centrally manage your Oracle 8i and Oracle 9i databases. Grid Control enables you to: • Perform day-to-day administration tasks • Monitor performance trends (from the Statspack data and dynamic performance views) • Find problem SQL • Perform real-time performance monitoring • View historical performance data • Set alerts and metric thresholds

  10. Monitoring Database Performance • Comprehensive database monitoring through Grid Control enables you to: • Identify the problem areas • Improve performance through tuning tasks • Leverage data from Automatic Workload Repository (AWR) to show performance information and initiate alerts • View performance through several real-time performance charts with drilldown capabilities

  11. Metric Baselines

  12. Baseline Normalized Views • Spot the abnormal performance characteristics easily.

  13. Using Advisors in Grid Control • From Advisor Central, there are several advisors available: • ADDM • Segment Advisor • Undo Management • Memory Advisor • SQL Access Advisor • SQL Tuning Advisor • MTTR Advisor

  14. Diagnosing Problems Automatically • Use Automatic Database Diagnostic Monitor (ADDM) to automatically: • Investigate and diagnose performance problems • Determine the cause • Provide advice on how to resolve it

  15. ADDM Page

  16. SQL Details

  17. Topology Viewer for SQL Details Plan

  18. Session Details

  19. Database Performance Page

  20. Database Performance Page

  21. Real-Time Monitoring Links • These pages have real-time diagnostic capabilities: • Top Activity • Top Consumers • Instance Activity • Historical SQL

  22. Top Activity

  23. Top Consumers

  24. Instance Activity

  25. Historical SQL (AWR)

  26. Active Session History (ASH) Report

  27. Diagnosing Problems Interactively • Investigate a problematic wait class. • Drill down to: • Session Details • SQL Details

  28. Active Sessions Waiting

  29. Hang Analysis • Diagnose locking issues by using Hang Analysis.

  30. Practice 9 Part 1 Overview: Common Managed Targets: Oracle Database • This practice covers the following topics: • Viewing the Database Home Page • Viewing Baseline Normalized Metrics • Monitoring Database Performance • Using the Hang Analysis Page

  31. Database Administration Features • Grid Control provides features for managing: • Security administration • Schema administration • Storage administration • Instance management • Backup and recovery • Resource consumer groups and plans • Source types such as packages, procedures, functions, and Java classes

  32. Tablespace Extent Map

  33. Database Auditing • You can use Grid Control to easily configure and monitor auditing. • Choose what to audit, based on: • Privileges • Objects • Statements • View audit trails: • Database audit trail • OS audit trail

  34. Migrating to Automatic Storage Management (ASM)

  35. Feature Usage Summary

  36. Multitarget SQL

  37. Multitarget SQL • You can also use the Enterprise Manager Command Line Interface (EM CLI) to perform multitarget SQL: • emcli execute_sql • [ -targets="name1:type1;name2:type2;..."] • [ -sql="FILE"] • [-credential_set_name="DBCredsSYSDBA"] • [-input_file="FILE:/scratch/schema.sql"]

  38. Database Maintenance Features • Grid Control provides features for maintenance tasks such as: • Backup and recovery • Import and export • Load data from user files • Clone a database • Transport a tablespace • Streams setup • Data Guard setup

  39. Load Data from User Files • Intelligent file sampling: • Preview data:

  40. Monitoring Real Application Clusters (RAC) • You can use Grid Control to manage the Real Application Cluster (RAC) database. Grid Control enables you to: • Manage clusters, cluster databases, and cluster database instances • Monitor performance statistics • Perform administration and maintenance tasks • Manage RAC features

  41. Cluster Database Topology Viewer

  42. Data Guard Management with Grid Control

  43. Summary • In this lesson, you should have learned how to: • Discuss Grid Control’s advantage over Database Control • Explain how Grid Control can be used to manage databases • Explain how Grid Control can manage older database versions (Oracle 8i and Oracle 9i) • Describe the Database Performance Monitoring features of Grid Control • Describe the Database Administration features of Grid Control • Describe the Database Maintenance features of Grid Control

  44. Practice 9 Part 2 Overview: Common Managed Targets: Oracle Database • This practice covers administering and maintaining Oracle Database.

More Related