Oracle 12c

Enterprise Manager Cloud Control 12c

Oracle Enterprise Manager Cloud Control 12c :

Grand Tour 2.0 Workshop : Feature Overview

1

Copyright © 2011, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 8

Agenda • Database Performance Management • Database Testing – Performance Testing – Test Data Management

• Database Lifecycle Management • Fusion Middleware Management

2



Database Performance Management • ASH Analytics to diagnose a slowly performing system • Walk through the entire process from discovery of a performance problem through diagnosis to identification of the poorly performing SQL • Real-Time ADDM to analyze problems in extremely slow or hung databases

3



Real-Time ADDM

• Real-time analysis of hung or slow database systems

• Holistically identify global resource contentions and deadlocks • Quantified performance impact • Precise, actionable recommendations • Provide cluster-wide analysis for RAC 4



Active Session History (ASH) Analytics • Advanced analysis with graphical ASH report • Select any time period for analysis • Analyze performance across many dimensions • Provides visual filtering for recursive drill-downs • Different visualizations: Stacked chart or Tree Map

• Collaborate with others using Active Reports 5



Agenda • Database Performance Management • Database Testing – Test Data Management – Performance Testing


6



Test Data Management Solutions Sensitive Data Identification

Data Relationship Modeling

7


Data Subsetting

Test System Setup


Data Masking

Sensitive Data Identification

Data Subsetting Production

What?


Data Subsetting

Test System Setup

Data Masking

• A relationally intact and yet fractional representation of production data for test and development purposes

Why?

Application data

• Reduce the storage overhead created by production data copies in various z application environments • Allow developers to perform real world application development by using production-class data 8



Application metadata

Subset criteria: REGION = ‘NORTH AMERICA’ AND FISCAL_YEAR = 2009

Test

Application data

Application metadata

Sensitive Data Identification

Secure Test System Deployment Data Masking


Production LAST_NAME

Test

Data Subsetting

Data Masking

Test System Setup

SSN

SALARY

LAST_NAME

SSN

AGUILAR

203-33-3234

60,000

SMITH

111-23-1111

60,000

BENSON

323-22-2943

40,000

MILLER

222-34-1345

40,000

SALARY

• Deploy secure test system by masking sensitive data • Extensible template library and policies for automation • Sophisticated masking: Condition-based, compound, deterministic • Integrated masking and cloning • NEW in EM 11g: Heterogeneous Data Masking • NEW in EM 11g: Pre- and Post-mask commands and command line (EMCLI) support • NEW in EM 12c: Data Masking integration with Real Application Testing • NEW in EM 12c: Key-based reversible masking 9



Secure Database Testing New in EM 12c

End-to-end testing with real workloads Create Test System

Capture Workload

Replay Workload

• SQL Performance Analyzer

Deploy Replay Clients

• Database Replay

• SQL unit testing for response time • Identify and tune regressed SQL • Integrated into SQL Tuning Advisor and SQL Plan Baseline

• Load, performance testing for throughput • Remediate application concurrency problems • Integrated with Oracle Application Testing Suite for superior comprehensive testing solution

• Seamless integration with Data Masking to preserve data privacy compliance 10



Secure Database Testing Real Application Testing Integration with Data Masking

Clone

Capture NAME

SALARY

111-22-3333

60,000

MILLER 112-23-4567

40,000

40,000

SMITH

BENSON

323-22-2943

60,000

Stage • Clone prod system • Consistent masking across tables, capture files, STS and AWR snapshots Insert Information Protection Policy Classification from Slide 8

Test

SSN

SALARY

203-33-3234

• DB Replay capture files • SQL Tuning Set (STS) • AWR snapshots


NAME

SSN

AGUILAR

Production

11

Mask

Test • Securely replay workload & STS



12



Database Lifecycle Management 1

Discovery & Provisioning

Discover assets and provision software on them

13


2

Patching & Change Management

End-to-end management of patches, upgrades, and schema changes


3

Configuration & Compliance Management

Track inventory, configuration drifts and compliance

Provisioning Databases Provision test, development or production systems

1

Enterprise Manager 12c Solutions Challenges and Problems Long and Error Prone process Lack of Standardization

Automated Mass Deployment Standardization using Provisioning Profiles Role and Access Separation

14



Patching 2

Maintain Patch Levels

Enterprise Manager 12c Solutions Challenges and Problems Predictability Downtime Management Scalability

15


Automated Mass Deployment Minimize Downtime, identify issues with pre requisite check Patch Templates and Compliance Standards


Configuration Management 3

Ensure Consistent Configurations

Enterprise Manager 12c Solutions Challenges and Problems Time Consuming Totally Reactive

Identify and Track Assets Compare Assets and Configurations Track and Remediate Drifts

Scalability

16





17



Fusion Middleware Management • Use one console to manage multiple domains across data center instead of managing each individually • Middleware page summarizes all domains’ status, version, compliance score • Domain Home page summarizes domain’s health • In context menus and drilldowns available throughout

18



Routing Topology for Fusion Middleware • Predefined and customizable, diagrammatic view of how FMW components are configured with one another • Understand farm/domain health, problem areas, and components impacted by those problems

19



FMW Customizable Performance Summary • Predefined and customizable performance summary views for correlating metrics across stack • Helps to quickly diagnose performance problems in realtime and from historical perspective across stack

20



JVM Diagnostics for a Composite Application • Provides 24/7 real-time and historical diagnostics with near-zero overhead (~0.25%) without byte code instrumentation • Analyze threads, heaps, overall JVM health with full, bidirectional, cross-tier capabilities to Oracle DB sessions

21



Middleware Diagnostics Advisor • Reduce time for root cause analysis via diagnostics findings • Recommendations to resolution calculated based on performance and configuration data collected across stack

22



Manage WLS Configurations Consistently • Automatically collect and store configuration data for WLS in order to determine if WLS is configured consistently with known reference configuration • Receive notifications of important differences in configurations

23



WLS Configuration History Reporting • Track changes to WLS configurations over time • Helps to diagnose performance problems as problems often due to configuration change

24



Ensure Compliance to Configuration Standards • Predefined and user-defined configuration standards • Former BEA Guardian healthchecks and signatures integrated as WebLogic Signature Rules • Ensure compliance to industry standards, Oracle recommendations, and internal best practices

25



Clone Domains and Deploy Java EE Applications • Reduce operational cost by automating installation, deployment, and configuration operations • Supported use cases include: – Clone Middleware Home (binaries only) or Clone Profile (domain config and binaries) from software library or from reference installation – Scale up/out domain/cluster – Deploy/redeploy/undeploy Java EE application(s) to domain(s) 26



Fusion Apps Target Recognition, Organization, and Navigation • Use one console to – manage multiple FA instances across data center instead of managing each individually – Showcase FA hierarchy (i.e., Instance, Product Family, Product, etc.), and their relationships – Showcase linkage between application and underlying technology components.

27



Understanding FA Metrics • Hundreds of out-of-the-box metrics – Administrators can utilize to make their system more efficient, reliable, and predictable. – Administrators can easily customize which metrics they want to view, monitor, and report on.

• Metric Extensions allow for the creation of metrics on any target type – a huge advantage over previous EM releases.

28



Efficient FA Management with Routing Topology • Provides out-of-the-box capabilities to – Show how targets relate to one another – Perform bottom-up analysis (i.e., Impact Analysis) and top-down analysis (i.e., Root Cause Analysis).

• Show how specific Product Families, Products, and Applications interact with respective technology components

29



Managing FA Configuration • Out-of-the-box capabilities to – Capture how each Product Family, Product, and Application – and their underlying technology stack - is configured. – Store, version, and provision configuration data, as well as compare data (e.g., Product) across time or between instances

30



Q&A

31



32



33



Oracle 12c

Recommend Documents