Enterprise Manager Cloud Control 12c
Oracle Enterprise Manager Cloud Control 12c :
Grand Tour 2.0 Workshop : Feature Overview
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
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
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
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 Subsetting
Data Relationship Modeling
Test System Setup
Data Masking
Copyright 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
Data Subsetting
What? A relationally intact and yet fractional representation of production data for test and development purposes
Production
Sensitive Data Identification
Data Subsetting
Data Relationship Modeling
Test System Setup
Data Masking
Why?
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 data
Application metadata
Subset criteria: REGION = NORTH AMERICA AND FISCAL_YEAR = 2009
Test
Application data
Application metadata
Secure Test System Deployment
Data Masking
Production
LAST_NAME AGUILAR BENSON SSN 203-33-3234 323-22-2943 SALARY 60,000 40,000 LAST_NAME SMITH MILLER
Sensitive Data Identification
Data Subsetting
Data Relationship Modeling
Data Masking
Test
SSN 111-23-1111 222-34-1345
Test System Setup
SALARY 60,000 40,000
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
Capture Workload Create Test System
Replay Workload
Deploy Replay Clients
SQL Performance Analyzer
Database Replay
Load, performance testing for throughput Remediate application concurrency problems Integrated with Oracle Application Testing Suite for superior comprehensive testing solution
SQL unit testing for response time Identify and tune regressed SQL Integrated into SQL Tuning Advisor and SQL Plan Baseline
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
Capture
NAME AGUILAR BENSON SSN
Clone
SALARY 40,000 60,000 203-33-3234 323-22-2943
Mask
NAME SMITH SSN 111-22-3333 SALARY 60,000 40,000
Test
MILLER 112-23-4567
Production DB Replay capture files SQL Tuning Set (STS) AWR snapshots
Stage Clone prod system Consistent masking across tables, capture files, STS and AWR snapshots
Insert Information Protection Policy Classification from Slide 8
Test
Securely replay workload & STS
11
Copyright 2011, Oracle and/or its affiliates. All rights reserved.
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
Patching & Change Management
Configuration & Compliance Management
Discover assets and provision software on them
End-to-end management of patches, upgrades, and schema changes
Track inventory, configuration drifts and compliance
13
Copyright 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
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
Maintain Patch Levels
2
Enterprise Manager 12c Solutions Challenges and Problems Predictability Downtime Management Scalability Automated Mass Deployment Minimize Downtime, identify issues with pre requisite check Patch Templates and Compliance Standards
15
Copyright 2011, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 8
Configuration Management
Ensure Consistent Configurations
3
Enterprise Manager 12c Solutions Challenges and Problems Time Consuming Totally Reactive Scalability Identify and Track Assets Compare Assets and Configurations Track and Remediate Drifts
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 domains 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
