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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
Agenda • Database Performance Management • Database Testing – Test Data Management – Performance Testing
• Database Lifecycle Management • Fusion Middleware Management
6
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
Test Data Management Solutions Sensitive Data Identification
Data Relationship Modeling
7
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Data Subsetting
Test System Setup
Insert Information Protection Policy Classification from Slide 8
Data Masking
Sensitive Data Identification
Data Subsetting Production
What?
Data Relationship Modeling
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 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
Data Relationship Modeling
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
NAME
SSN
AGUILAR
Production
11
Mask
Test • Securely replay workload & STS
Agenda • Database Performance Management • Database Testing – Performance Testing – Test Data Management
• Database Lifecycle Management • Fusion Middleware Management
12
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
Database Lifecycle Management 1
Discovery & Provisioning
Discover assets and provision software on them
13
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
2
Patching & Change Management
End-to-end management of patches, upgrades, and schema changes
Insert Information Protection Policy Classification from Slide 8
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
Patching 2
Maintain Patch Levels
Enterprise Manager 12c Solutions Challenges and Problems Predictability Downtime Management Scalability
15
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Automated Mass Deployment Minimize Downtime, identify issues with pre requisite check Patch Templates and Compliance Standards
Insert Information Protection Policy Classification from Slide 8
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
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
17
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
WLS Configuration History Reporting • Track changes to WLS configurations over time • Helps to diagnose performance problems as problems often due to configuration change
24
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
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
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
Q&A
31
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
32
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
33
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8