Transcript Database
Common Managed Targets: Database Copyright © 2006, Oracle. All rights reserved. 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 9-2 Copyright © 2006, Oracle. All rights reserved. Ways to Manage Your Database Grid Control Management Repository 9-3 Copyright © 2006, Oracle. All rights reserved. Database Control Grid Control Versus Database Control Feature Grid Control Database Control Installation Separate DB 10g Management Centralized In local DB 10g Management One per host in One per DB 10g Home Agent separate home Target Type Many Single DB 10g Number of DBs Many One EM job System Yes Yes Cluster DB (RAC) Yes Yes Repository 9-4 Copyright © 2006, Oracle. All rights reserved. Grid Control Versus Database Control Feature Grid Control Database Control Config. mgmt. Enterprisewide Local system Data Guard Yes No (Standby DB) 9-5 Copyright © 2006, Oracle. All rights reserved. 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 9-6 Copyright © 2006, Oracle. All rights reserved. Database Home 9-7 Copyright © 2006, Oracle. All rights reserved. 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-9 Copyright © 2006, Oracle. All rights reserved. Managing Oracle 8i and 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 9 - 10 Copyright © 2006, Oracle. All rights reserved. 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 9 - 12 Copyright © 2006, Oracle. All rights reserved. Metric Baselines 9 - 13 Copyright © 2006, Oracle. All rights reserved. Baseline Normalized Views Spot the abnormal performance characteristics easily. 9 - 14 Copyright © 2006, Oracle. All rights reserved. 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 9 - 15 Copyright © 2006, Oracle. All rights reserved. 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 9 - 16 Copyright © 2006, Oracle. All rights reserved. ADDM Page 9 - 17 Copyright © 2006, Oracle. All rights reserved. SQL Details 9 - 18 Copyright © 2006, Oracle. All rights reserved. Topology Viewer for SQL Details Plan 9 - 19 Copyright © 2006, Oracle. All rights reserved. Session Details 9 - 20 Copyright © 2006, Oracle. All rights reserved. Database Performance Page 9 - 21 Copyright © 2006, Oracle. All rights reserved. Database Performance Page 9 - 22 Copyright © 2006, Oracle. All rights reserved. Real-Time Monitoring Links These pages have real-time diagnostic capabilities: • Top Activity • Top Consumers • Instance Activity • Historical SQL 9 - 23 Copyright © 2006, Oracle. All rights reserved. Top Activity 9 - 24 Copyright © 2006, Oracle. All rights reserved. Top Consumers 9 - 26 Copyright © 2006, Oracle. All rights reserved. Instance Activity 9 - 27 Copyright © 2006, Oracle. All rights reserved. Historical SQL (AWR) 9 - 28 Copyright © 2006, Oracle. All rights reserved. Active Session History (ASH) Report 9 - 29 Copyright © 2006, Oracle. All rights reserved. Diagnosing Problems Interactively 1. Investigate a problematic wait class. 2. Drill down to: – Session Details – SQL Details 9 - 30 Copyright © 2006, Oracle. All rights reserved. Active Sessions Waiting 9 - 31 Copyright © 2006, Oracle. All rights reserved. Hang Analysis Diagnose locking issues by using Hang Analysis. 9 - 32 Copyright © 2006, Oracle. All rights reserved. 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 9 - 33 Copyright © 2006, Oracle. All rights reserved. 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 9 - 34 Copyright © 2006, Oracle. All rights reserved. Tablespace Extent Map 9 - 35 Copyright © 2006, Oracle. All rights reserved. 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 9 - 36 Copyright © 2006, Oracle. All rights reserved. Migrating to Automatic Storage Management (ASM) 9 - 37 Copyright © 2006, Oracle. All rights reserved. Feature Usage Summary 9 - 38 Copyright © 2006, Oracle. All rights reserved. Multitarget SQL 9 - 39 Copyright © 2006, Oracle. All rights reserved. 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"] 9 - 40 Copyright © 2006, Oracle. All rights reserved. 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 9 - 41 Copyright © 2006, Oracle. All rights reserved. Load Data from User Files Intelligent file sampling: Preview data: 9 - 42 Copyright © 2006, Oracle. All rights reserved. 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 9 - 43 Copyright © 2006, Oracle. All rights reserved. Cluster Database Topology Viewer 9 - 44 Copyright © 2006, Oracle. All rights reserved. Data Guard Management with Grid Control 9 - 45 Copyright © 2006, Oracle. All rights reserved. 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 9 - 46 Copyright © 2006, Oracle. All rights reserved. Practice 9 Part 2 Overview: Common Managed Targets: Oracle Database This practice covers administering and maintaining Oracle Database. 9 - 47 Copyright © 2006, Oracle. All rights reserved.