common managed targets database n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Common Managed Targets: Database PowerPoint Presentation
Download Presentation
Common Managed Targets: Database

Loading in 2 Seconds...

play fullscreen
1 / 44

Common Managed Targets: Database - PowerPoint PPT Presentation


  • 135 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Common Managed Targets: Database' - jalila


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
objectives
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
ways to manage your database
Ways to Manage Your Database

Grid Control

Database Control

Management

Repository

grid control versus database control
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

grid control versus database control1
Grid Control Versus Database Control

Feature

Grid Control

Database Control

Config. mgmt.

Enterprisewide

Local system

Data Guard (Standby DB)

Yes

No

accessing grid control versus database control
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

managing databases
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.
managing oracle 8 i and oracle 9 i databases
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
monitoring database performance
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
baseline normalized views
Baseline Normalized Views
  • Spot the abnormal performance characteristics easily.
using advisors in grid control
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
diagnosing problems automatically
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
real time monitoring links
Real-Time Monitoring Links
  • These pages have real-time diagnostic capabilities:
    • Top Activity
    • Top Consumers
    • Instance Activity
    • Historical SQL
diagnosing problems interactively
Diagnosing Problems Interactively
  • Investigate a problematic wait class.
  • Drill down to:
    • Session Details
    • SQL Details
hang analysis
Hang Analysis
  • Diagnose locking issues by using Hang Analysis.
practice 9 part 1 overview common managed targets oracle database
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
database administration features
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
database auditing
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
multitarget sql1
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"]
database maintenance features
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
load data from user files
Load Data from User Files
  • Intelligent file sampling:
  • Preview data:
monitoring real application clusters rac
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
summary
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
practice 9 part 2 overview common managed targets oracle database
Practice 9 Part 2 Overview: Common Managed Targets: Oracle Database
  • This practice covers administering and maintaining Oracle Database.