Tuesday Mar 12, 2013

WEBCAST: Delivering Database as a Service with Oracle Enterprise Manager 12c


Thursday March 14
10:00 a.m. PST / 1:00 p.m. EST

Join us for a live Webcast to find out about the recently released Oracle Enterprise Manager 12c plug-ins that deliver new capabilities and support for managing database cloud services with schema as a service for extreme database consolidation and quick efficient database cloning through Snap Clone or RMAN Backups. These new capabilities provide an optimum utilization of development and database resources giving customers more flexibility and control during application development, leading to a faster time-to-market for delivering IT services.

Register Now!

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager Cloud Control12c Mobile app

Friday Mar 08, 2013

Schema as a Service for Extreme Consolidation

As we deal with Database as a Service use cases, we often find that consumers do not need dedicated databases of their own. Developers of a home-grown application, for example, might be satisfied with a logical slice of the database. This logical slice, leads us to the concept of Schema as a Service—a new capability offered in the latest release of Oracle Enterprise Manager 12c Release 2 Plug-in Update 1.

Schema as a service is the ultimate and extreme in consolidating multiple schemas in a shared database model. Cloud users can request one or more schemas, with or without seed data, from Oracle Enterprise Manager 12c’s out-of-the-box self service portal. It offers excellent manageability, not only for its fast efficient provisioning, but because administrators only need to manage a small number of databases.


Schema as a Service: Consolidate Multiple Schemas in a Shared Database Cloud Services Model

However, consolidation comes at the expense of isolation, because the operating system and database are not isolated among the database consumers. While enabling Schema as a Service, it’s important to isolate the workloads as much as possible to make sure that one user doesn't run away with all the database resources. Administrators can guarantee this does not happen by using Oracle Enterprise Manager 12c’s CPU monitoring capabilities built in to Oracle Database Resource Manager to maintain service levels.

For security, the more consolidated you get, the more concerns administrators have about data isolation and security. Using Oracle Data Vault can help resolve these issues. It is integrated with Oracle Enterprise Manager 12c, and administrators can use Oracle Data Vault to enable fine grain control based on roles and privileges within the database cloud service.

For reporting purposes, metering and chargeback capabilities can be implemented to help IT organizations gain in-depth visibility into resource consumption and expenses incurred with each schema as a service deployment. This is useful for regulatory compliance requirements as well.

Schema as a Service at a Glance:

  • Consolidate multiple application schemas in a shared database deployment model
  • Each application user (i.e. developers or testers) can provision one or more database schema(s) with a dedicated database cloud service
  • Automated placement can be based on workload characteristics and specifications
  • Service levels are guaranteed through Oracle Database Resource Manager
  • Service governance is done through quotas, retirement policies and chargeback plans
  • Integrated with Oracle Data Vault for security isolation and control
  • De-provision schemas when needs change

Benefits:

  • Save resources through ultimate consolidation of multiple database applications
  • Boost administrator productivity and increase efficiency with automated provisioning
  • Deploy schema as a service implementations consistently using self-service profiles and templates
  • Metering and chargeback helps keep track of resource consumption and usage for accountability and reporting
  • Minimize administrative overhead and compliance challenges by preventing database sprawl

How To:
There are several steps involved when setting up and deploying database schema as a service in Oracle Enterprise Manager’s self service portal. Here is a quick summary of what’s involved. For more details be sure to review the resources below.

1. Setting up Platform as a Service Zones

  • Before deploying your schema as a service, you first need to create a Platform as a Service (PaaS) infrastructure using Oracle Enterprise Manager 12c’s self-service portal. A PaaS Zone comprises multiple hosts, i.e. servers with Oracle Enterprise Manager 12c agent installed.
  • Use the portal to create a PaaS zone and organize it by function type (i.e. based on geography, line of business (sales, development) or application lifecycle. (i.e. dev, test, QA, production)
  • Next expose the PaaS zone to the self-service cloud users in the portal. For example, developers can now have the option to select a development PaaS zone or testers can select a QA zone.
  • Visibility of each zone can be restricted based on the self-service user's credentials.

2. Setting up Database Pools

  • Database pools are a collects of databases used to host schema as a service.
  • To create a new database pool, you can use a portion of resources that are available to the zone. Keep in mind that all members of the database pool need to be the same target type. For example, a single database instance or database cluster; platform, or same database version. This ensures provisioning consistency during deployment.
  • Next configure placement constraints and policies for the database pool. For placing databases within the pool and controlling how resources are utilization, you need to first create a placement constraint and set its policies. This provides protection for the database members within the pool for resource consumption. For example, a production database pool might enforce more conservative constraints whereas a development pool might allow liberal limits.
  • You can set a constraint for each database in the pool by services or by workload associated with the service request based on CPU and memory. You can also enable Oracle Database Resource Manager for the database pool to control your CPU usage and the underlying service levels.

3. Request Settings

  • During this part of the schema as a service set up, future reservations, archive retention and duration of request can all be enabled.

4. Quotas

  • Controlling quotas and setting limits for users based on role level can be assigned in this step of the process. Oracle Enterprise Manager supports quota based on CPU, memory and number of database services.

5. Profiles and Service Templates

  • A service template is standardized definition that is offered to self-service users to create a database or schemas within the deployment. A service template defines the workload characteristics and schema details that can be generated with or without seed data.
  • To create a service template with seed data, you need to create a profile. A profile is an entity that captures source database information for provisioning purposes. Once you create your service template it becomes part of a collection which makes up the service catalog. This catalog is then exposed to cloud users in the self-service portal.
  • Next, you can either export the seed data from the source database or export the schema definitions without the data. Once you decide, a Data Pump Export job will be created.
  • You can now map your newly created profile and service templates to the required zone(s) and database pools.

6. Chargeback

  • The final step in deploying schema as a service is to configure resource metering and chargeback.
  • Setting up metering and chargeback can easily be done in order to track resource usage within the schema as a service implementation.
  • For more information on how to set up chargeback we recommend reading this white paper.

LEARN MORE:

Product Info:
  • Oracle Cloud Management
  • Zero to Cloud Resource Center
  • Demos:
  • Oracle Cloud Management
  • Setting up Database Clouds for Schema as a Service
  • Whitepapers:
  • Delivering Database as a Service using Oracle Enterprise Manager 12c
  • Best Practices for Database Consolidation in Private Clouds
  • Oracle Enterprise Manager 12c: Metering and Chargeback
  • Cloud Management for Oracle Database

  • Stay Connected:
    Twitter |
    Facebook | YouTube | Linkedin | Newsletter
    Download the Oracle Enterprise Manager Cloud Control12c Mobile app

    Tuesday Mar 05, 2013

    Webcast: New Cloud Management Plug-Ins Provide Enhanced Capabilities for Deploying and Managing Clouds


    Thursday March 7
    10:00 a.m. PST / 1:00 p.m. EST

    Join us for this presentation to learn about Oracle Enterprise Manager 12c's recent release of new and updated Management Plug-ins that provide optimum utilization of compute resources, ultimately leading to faster time-to-market for IT services delivery. In addition to providing enhanced cloud management support, the Plug-ins extend Oracle Enterprise Manager 12c's capabilities for Database as a Service (DBaaS) and Infrastructure as a Service (Iaas), as well as introduce new features for Testing as a Service (TaaS).

    Register Now!

    Stay Connected:
    Twitter |
    Facebook | YouTube | Linkedin | Newsletter
    Download the Oracle Enterprise Manager Cloud Control12c Mobile app

    Tuesday Feb 12, 2013

    SquareTwo Financial uses Oracle Data Masking for Compliance and Improves Performance by 96%

    Watch as leading financial services firm, SquareTwo Financial, talks about maintaining compliance while increasing IT productivity and performance by replacing in-house data masking with Oracle Data Masking solution.

    Stay Connected:
    Twitter |
    Facebook | YouTube | Linkedin | Newsletter
    Download the Oracle Enterprise Manager Cloud Control12c Mobile app

    Friday Feb 08, 2013

    Gartner Positions Oracle in Leaders Quadrant for Data Masking

    Gartner recently announced that Oracle Data Masking Pack, part of Oracle Enterprise Manager’s quality management and Oracle Database Security defense-in-depth solution, has been named a leader in the first Magic Quadrant for Data Masking Technology report.

    Oracle Data Masking strengths highlighted in the report include:

    • High performance data masking in Oracle Databases
    • Integration into Oracle Enterprise Manager 12c resulting in easy adoption
    • Availability of pre-built templates for popular packaged systems such as, Oracle E-Business Suite
    • Database security expertise and strong DBMS security portfolio

    About Oracle Data Masking
    Oracle Data Masking ensures privacy by transforming sensitive data before it is transferred to test, QA, and other non-production environments, addressing regulatory compliance for both Oracle and non-Oracle Databases.


    Oracle Data Masking Pack: Production data is cloned and masked before being copied to Test.

    Key Features:

    • Application data discovery
    • Centralized extensible format library
    • Comprehensive mask techniques
    • High performance masking with role-based security
    • Optimized for Oracle and non-Oracle databases
    • Integrated with Oracle testing products
    • Integrated with data subsetting

    Oracle Data Masking completely replaces sensitive information such as; names, account numbers, SSNs, financial results, purchasing transactions, etc. in your development, test and QA systems with data that cannot be “reverse engineered” to reveal its original source. This allows production data to be safely used for development, testing, or sharing with out-source or off-shore partners for other non-production purposes. The Pack provides extensive search capabilities to scan enterprise databases for sensitive data discovery based on established data patterns and models.

    The solution allows masking of all the related data elements automatically while preserving referential relationships combining the sensitive data columns and associated relationships in an Application Data Model. Oracle Data Masking can detect data dependencies, such as foreign key constraints and replaces sensitive information transparently. This ensures that the referential integrity necessary for applications to work and function properly will continue be in place, even on development systems.

    Benefits:

    • Administrators will save time and eliminate risk by replacing individual scripts and routines written by DBAs with centrally managed and deployed libraries of masking processes.
    • Provides secure, scalable and automated solution to create test environments from production data using bulk masking.The solution enables faster time-to-market by speeding up the development process while helping organizations comply with privacy regulations and confidentiality policies.
    • Enables rapid DBA productivity through the use of application masking templates.
    • Supports custom data masks that are defined once and can be used every time that set of data needs to be masked.
    • Data security is integrated within the application management lifecycle, meaning that DBAs can provide realistic-masked production data to developers or testing groups for accurate application testing while reducing their storage costs by not having to provision an entire production environment for each developer or project.
    • Oracle Data Masking Pack is built into and installed with Oracle Enterprise Manager 12c.

    Data Masking for Security and Compliance
    Oracle Data Masking offers a comprehensive and customizable library of masking formats, templates and policies that can be used to replace sensitive information with realistic simulated values—all with just a few mouse clicks. The sensitive data never has to leave the Oracle Database or the production environment. This maintains data security and compliance through privacy and confidentiality polices on shared production data. The solution helps protect against unauthorized access to data that is being shared with off-shore developers, partners or 3rd party vendors.


    Oracle Data Masking Pack: Centralized Extensible Format Library.

    In addition, Oracle Data Masking allows organizations to enforce compliance with regulatory requirements such as; Sarbanes-Oxley, Payment Card Industry Data Security Standards, Health Insurance Portability and Accountability Act, as well as numerous other laws and regulations that restrict the use of actual customer data.

    Oracle Data Masking continues to gain strong adoption, check out the latest customers to see how they are benefiting from the solution:

    LEARN MORE:

    Stay Connected:
    Twitter |
    Facebook | YouTube | Linkedin | Newsletter
    Download the Oracle Enterprise Manager Cloud Control12c Mobile app

    Wednesday Jan 30, 2013

    Coles Deploys Oracle Exadata and Oracle Enterprise Manager 12c

    Read the latest news about Coles Supermarkets, one of Australia's largest grocery chains with more than 100,000 employees and 2,000 stores country-wide. Learn how Coles completely revamped their data warehouse with Oracle Exadata and Oracle Enterprise Manager 12c . The new system improved Coles's processes and critical reporting by as much as 3 to 4x out-of-the-box with a 4 to 6x faster query performance. The result, higher quality of service for the business and for customers during peak seasonal spikes.

    LEARN MORE:

    Stay Connected:
    Twitter |
    Facebook | YouTube | Linkedin | Newsletter
    Download the Oracle Enterprise Manager Cloud Control12c Mobile app

    Tuesday Jan 29, 2013

    WEBCAST: Protect Your Sensitive and Confidential Data Using Oracle Data Masking Solution

    Thursday February 7
    10:00 a.m. PST / 1:00 p.m. EST

    Join us for a live and interactive webcast on how to comply with regulatory requirements and data protection policies by protecting sensitive data in non-production Oracle Databases as well as non-Oracle databases using Oracle Data Masking Pack, a part of Oracle Enterprise Manager 12c quality management and Oracle Database Security defense-in-depth solution. Topics include:

    • Automatically discovering sensitive data
    • Standard and advanced masking techniques made easy
    • Eliminate the need for a staging database using At-source masking
    • Secure your Oracle Applications (Oracle E-Business Suite, Oracle Fusion Applications) data quickly using masking templates
    • Seamless masking integration with Oracle's data subsetting solution
    Register today
    Stay Connected:
    Twitter |
    Facebook | YouTube | Linkedin | Newsletter
    Download the Oracle Enterprise Manager Cloud Control12c Mobile app

    Friday Jan 25, 2013

    Enterprise Manager for Big Data Appliance (BDA) Plugin - 12.1.0.1.0

    Earlier this month (Jan 2013) we announced the GA of Enterprise Manager for Big Data Appliance (BDA) Plugin - 12.1.0.1.0

    This is the first version of Enterprise Manager for Big Data Appliance (BDA) Plugin release. The plugin is available to EM customers on Self Update (screenshot below), and certification information for this plugin is also available to customers on MyOracleSupport certify (here).


    BDA
    Using the Enterprise Manager 12c Big Data Appliance Plug-in 12.1.0.1, users can:

    1. Discover the software and hardware components of a Big Data Appliance Network and add them as managed targets.
    2. Manage the hardware and software components that comprise a Big Data Appliance Network as a single target or as individual targets.
    3. Study collected metrics to analyze the performance of the network and each Big Data Appliance component.
    4. Trigger alerts based on availability and system health.
    5. Respond to warnings and incidents.

    Stay Connected:
    Twitter |
    Facebook | YouTube | Linkedin | Newsletter


    Thursday Jan 24, 2013

    HDFC Bank Deploys Database-as-a-Service with Oracle Enterprise Manager 12c

    Listen in as one of India’s largest banks discusses the benefits of using Oracle Enterprise Manager 12c to manage their database-as-a-service deployment.

    Stay Connected:
    Twitter |
    Facebook | YouTube | Linkedin | Newsletter
    Download the Oracle Enterprise Manager Cloud Control12c Mobile app

    Friday Jan 18, 2013

    Enterprise Manager at Collaborate13

    LAST UPDATED: April 4, 2013

    Enterprise Manager customers and partners will once again be widely represented at Collaborate13, the annual conference of the Independent Oracle User Group (IOUG), Oracle Applications User Group (OAUG)  and Quest International Users Group.

    As reported in my blog about Enterprise Manager in the Oracle User Community, IOUG’s Enterprise Manager Special Interest Group (SIG) has grown substantially since its inception in 2012 and has a comprehensive line-up of best practices and real-world experiences from Enterprise Manager customers and partners as well as sessions featuring speakers from Oracle Development. A listing of sessions featuring Enterprise Manager exclusively or significantly is below.

    Note: Use the Education Scheduler to get the abstract for the session by doing a search using the Session ID. 

    MONDAY APRIL 8

    ID Title Speaker & Company Time & Location

    344

    Performance Tuning your DB Cloud in OEM 12c Cloud Control - 360 Degrees Tariq Farooq - Brain Surface
    09:45 am - 10:45 am
    Mile High Ballroom 4A
    951 Oracle's Cloud Computing Strategy Anand Akela - Oracle
    11:00 am - 12:00 pm
    Four Seasons Ballroom 1
    669 ASH: Architecture and Advanced Usage - Part 1 of 2 John Beresniewicz - Oracle
    11:00 am - 12:00 pm
    Mile High Ballroom 3A
    100240 Peoplesoft Application and System Monitoring Basics Raj Garrepally - Georgia Health Sciences University
    11:00 am - 12:00 pm
    Room 107
    436 Cloud Computing Solutions leveraging Oracle Technology Jordan Braunstein - Visual Integrator Consulting
    12:15 pm - 12:45 pm
    Mile High Ballroom 4A
    250 How to Become a Cloud Builder Steve Lemme - Oracle
    1:15 pm - 2:15 pm
    Mile High Ballroom 4A
    183 EM12c- Less Known Features and Techniques Kellyn Pot'Vin - Enkitec
    1:15 pm - 2:15 pm
    Mile High Ballroom 4C
    577 "Where did my CPU go?" -- Monitoring & Capacity Planning Adventures on a Consolidated Environment Karl Arao - Enkitec
    1:15 pm - 2:15 pm
    Mile High Ballroom 3A
    851 Manage Large RAC Clusters Tom Reddy - Database Administraion, Inc.
    1:15 pm - 2:15 pm
    Mile High Ballroom 2A
    319 Automating Database Security Compliance using OEM 12c Bobby Curtis - BIAS
    2:30 pm - 3:30 pm
    Mile High Ballroom 1D
    772 Deploying a Private DB Cloud Michael Timpanaro - Oracle
    2:30 pm - 3:30 pm
    Mile High Ballroom 4A
    255 OEM Command Line Interface Illustrated Ray Smith - PGE
    3:45 pm - 4:45 pm
    Mile High Ballroom 4C
    11362 Off the Farm and Into the Enterprise - Oracle Enterprise Manager Floyd Teter - EiS Technologies
    3:45 pm - 4:45 pm
    Room 507
    128 ASH: Architecture and Advanced Usage - Part 2 of 2 John Beresniewicz - Oracle
    3:45 pm - 4:45 pm
    Mile High Ballroom 2A
    720 Listener Poisoning? Logminer fragmentation? Million Cursors opened? Manageability Headaches or Opportunities in Disguise Raghav Pujari - PSDB Solutions Inc
    3:45 pm - 4:45 pm
    Mile High Ballroom 2B
    609 Oracle Enterprise Manager 12c in an HA configuration across Data Centers Todd Bellaver - Secure-24
    5:00 pm - 6:00 pm
    Mile High Ballroom 4C
    Kiosk #6 Enterprise Manager 12c Total Cloud Control Demo Oracle
    6:00 pm - 8:00 pm
    Oracle Demogrounds




    TUESDAY APRIL 9

    ID Title Speaker & Company Time & Location
    343 Oracle VM, OEM 12c and Cloud Computing 360 Degrees

    Kai Yu - Dell

    Tariq Farooq - Brain Surface

    Michael Ault - Ramsan


    8:00 am - 9:00 am
    Mile High Ballroom 4A
    814 Leveraging Enterprise Manager to uncover virtualization performance bottlenecks Bryce Kaiser - Blue Medora
    8:00 am - 9:00 am
    Mile High Ballroom 4E
    Kiosk #6 Enterprise Manager 12c Total Cloud Control Demo Oracle
    10:15 am - 3:15 pm
    Oracle Demogrounds
    264 Enterprise Manager 11g - Making Life Easier For You William Robbins - College of William & Mary
    12:00 pm - 12:30 pm
    Mile High Ballroom 2B
    630 Oracle Enterprise Manager 12c: Architecture Deep-dive, Tips, Techniques Mark McGill - Oracle
    2:00 pm - 3:00 pm
    Mile High Ballroom 4C
    563 Oracle Enterprise Manager 12c: Nerve Center of the Oracle Cloud Nara Gogineni - Oracle
    2:00 pm - 3:00 pm
    Mile High Ballroom 2C
    544 Be a hero with your DBAs: DB Tuning for Sys Admins and IT Architects Randall Sogrillo - Oracle
    2:00 pm - 3:00 pm
    Mile High Ballroom 2B
    237 Plan/Configure/Deploy your own Private Oracle Fusion Applications Cloud Tariq Farooq - Brain Surface
    2:00 pm - 3:00 pm
    Mile High Ballroom 3C
    580 RAC 11gR2 performance using AWR data and OEM 12c - Lessons learned from a critical production system Tim Quinlan - Scotiabank
    2:00 pm - 3:00 pm
    Mile High Ballroom 4A
    589 Oracle Enterprise Manager 12c: Deployment Best Practices Werner de Gruyter - Oracle
    4:30 pm - 5:30 pm
    Mile High Ballroom 2A
    326 Configuring Oracle Enterprise Manager Cloud Control 12c for High Availability Leighton Nelson - Nelson
    4:30 pm - 5:30 pm
    Mile High Ballroom 4C
    941 Cloud Control Recipes Mike Gangler - ITHAKA
    4:30 pm - 5:30 pm
    Mile High Ballroom 4A
    Kiosk #6 Enterprise Manager 12c Total Cloud Control Demo Oracle
    5:30 pm - 7:00 pm
    Oracle Demogrounds




    WEDNESDAY APRIL 10

    ID Title Speaker & Company Time & Location
    400 How is your network supporting your Oracle Applications and Databases and ultimately your business? John McHugh - Entuity
    8:15 am - 9:15 am
    Mile High Ballroom 4E
    679 Exadata 101 -- What You Need to Know Rich Niemiec - ROLTA
    8:15 am - 9:15 am
    Mile High Ballroom 1C
    800 Best Practices for implementing Oracle Database as a Service Raj Kammend - Oracle
    8:15 am - 9:15 am
    Mile High Ballroom 4A
    815 Oracle Enterprise Manager SIG - Birds of a Feather

    Twitter #em12c

    TweetEvite


    9:30 am - 10:30 am
    Mile High Ballroom 4B & Chatroom
    Kiosk #6 Enterprise Manager 12c Total Cloud Control Demo Oracle
    10:30 am - 3:00 pm
    Oracle Demogrounds
    325 Managing Heterogeneous Virtualization Environments with EM12c Bryce Kaiser - Blue Medora
    12:15 PM - 12:45 PM
    Mile High Ballroom 4A

    Enterprise Manager - Book Signing Adeesh Fulay - Oracle
    12:15 PM - 12:45 PM
    Bookstore
    864 Upgrading from Oracle Enterprise Manager 10g to Cloud Control 12c with Zero Downtime Leighton Nelson - Mercy
    3:00 pm - 4:00 pm
    Mile High Ballroom 4C
    12983 Advanced Management of Oracle E-Business Suite with Oracle Enterprise Manager Angelo Rosado - Oracle
    3:00 pm - 4:00 pm
    Room 601
    369 Simplifying Application Deployment in Cloud using Virtual assemblies and EM 12c Kai Yu - Dell
    4:15 pm - 5:15 pm
    Mile High Ballroom 4B
    182 Engineered Systems Curriculum: 500+ Million Records per Day Replicated to Exadata using GoldenGate Kirby McCord - US Cellular
    4:15 pm - 5:15 pm
    Mile High Ballroom 1C




    THURSDAY APRIL 11

    ID Title Speaker & Company
    Time & Location
    336 Near Zero Downtime Oracle RAC Migration with Oracle Automatic Storage Management and OEM 12c

    Vinod Emmanuel 9:45 am - 10:45 am
    Dell Mile High Ballroom 2A
    837 Shed Some Light on the Bumps in the Night with Enterprise Manager 12c David Start - Johnson Controls
    9:45 am - 10:45 am
    Mile High Ballroom 2B

    Thursday Jan 17, 2013

    Enterprise Manager in the Oracle User Community

    Top brass representing Oracle user groups from around the world converged at the user community’s annual Leaders’ Summit held at Oracle HQ this past week.  An increased desire to introduce or increase involvement with Enterprise Manager to the members of their respective organizations was clearly expressed to product representatives who attended, like me!

    The reason?  The most active, involved and (dare I say) demanding customers participate in 450 groups representing 275,000 Oracle customers.  Adoption of Enterprise Manager 12c is accelerating and is being used to manage more and more Oracle and non-Oracle parts of their IT stack by these customers.   Members are becoming increasingly expert in deploying and using Enterprise Manager and are eager to share their experiences with their peers.  All this adds up to members wanting a focus on it so they can learn more about it, share best practices and maybe even influence product direction.  That's why the interest is there.

    Want proof?  In the last year or so, two user groups now have a special interest groups (SIGs) devoted to management: IOUG and UKOUG.  Others, such as DOAG and AUSOUG, prominently feature Enterprise Manager at their respective conferences.  ODTUG, Quest and even the Georgia User Group have just begun investigating how to feature Enterprise Manager in their groups, and  no doubt there will be more.

    A very noteworthy example is IOUG's Enterprise Manager SIG.  At Oracle OpenWorld SIG Sunday last October, six extremely well-attended manageability sessions under the auspices of the SIG were held.  IOUG will also be launching a bi-monthly E-news briefing and web-cast series starting in the March 2013 time-frame.  And to top it off, IOUG along with OAUG is also featuring 30-plus sessions devoted exclusively or significantly to Enterprise Manager at the upcoming Collaborate13 Conference in Denver April 7-11th.  That's unprecedented.  Check out my Enterprise Manager at Collaborate13 blog for the session listing.


    Okay, now I'm going out on a limb:  the Oracle Enterprise Manager product team stands ready to help your user group establish an focus around manageability in any practical way possible.  We can provide speakers for your upcoming conferences or webcasts.  We can apply social media resources.  And we are more than happy to apply other marketing resources where they make sense.  We are very interested in supporting a management special interest group as well. 

    Just contact me at joe.diemer@oracle.com.  Operators are standing by.

    Stay Connected with Oracle Enterprise Manager:
    Twitter |
    Facebook | YouTube | Linkedin | Newsletter

    Tuesday Jan 15, 2013

    Answers to Your Common Database Performance Questions

    An Interview with Oracle Database Manageability Expert, Deba Chatterjee

    Throughout the year we hear from lots of customers and get many questions about managing Oracle Database. In this blog, I thought I would try and provide some answers to common diagnostics and tuning questions with the help of our product manager and residence expert for Oracle Database Manageability, Deba Chatterjee. Deba has a wealth of database performance tuning experience both inside and outside of Oracle managing large data warehouses. Deba is responsible for Oracle Diagnostics Pack for Database and Oracle Tuning Pack for Database. I recently sat down with Deba and had a chat about database manageability.

    Scott McNeil: Deba, we get many people asking questions about database performance—many still don't know about all the deep diagnostics capabilities Oracle Enterprise Manager 12c has to offer for Oracle Database. Capabilities such as; Compare Period ADDM, Real-Time ADDM, Active Session History (ASH) Analytics Real-Time SQL Monitoring, using Metric Extensions, and SQL Tuning Advisor—how do customers get all these capabilities for their database?

    Deba Chatterjee: We recently ran a webcast: Maximize Oracle Database Performance with Oracle Enterprise Manager 12c: Top 10 Tips and Tricks that explains how many of these features work. I highly recommend people watch the webcast to get a better understanding of the capabilities you mentioned. But the short answer is: for Compare Period ADDM, Real-Time ADDM, Metric Extensions you need to license Oracle Enterprise Manager 12c Diagnostics Pack for Database. For Real-Time SQL Monitoring, SQL Tuning Advisor, you will need the Oracle Tuning Pack for Database.

    Scott McNeil: Another question customers repeatedly ask is around Cloud Control and Database Control. Deba, can you explain the difference between Oracle Enterprise Manager Cloud Control 12c (formerly Grid Control) and Database Control.

    Deba Chatterjee: Although they belong to the same family of products there is a fundamental difference between the two. Database Control can be used to manage only a single database with which it has been configured, while Oracle Enterprise Manager Cloud Control 12c allows you to manage all your databases under the same centralized management console. Plus Cloud Control lets you manage not only all your databases but your entire application and technology stack too, whether it's in a private cloud or in a traditional environment.

    How do you modify the Metric Value History retention in Enterprise Manager? For example; Enterprise Manager only shows the last 7 days, how do you display longer than 7 days?

    Deba Chatterjee: There are various retention times based on the type of metric data:

    • Raw metric data: default retention time is 7 days
    • Hourly aggregated metric data: default retention is 31 days
    • Daily aggregated metric data: default retention is 12 months

    Refer to the documentation here, if you want to change the default retention time.

    For Compare Period ADDM, how do you relate that in the context of system load?

    Deba Chatterjee: In the resource usage tab, you can check the system CPU, Memory, I/O and interconnect (for RAC databases) utilizations across the 2 comparison periods in the same database.

    Does Compare Period ADDM take into account the average read and average write in order to identify why the variance is happening in performance?

    Deba Chatterjee: Compare Period ADDM uses database time to compare the performance across two periods. It does not compare based on average read or write times.

    Does Enterprise Manager have the ability to create customized performance graphs? For example; can you create a graph for CPU usage in the last 24 hours on a given Host?

    Deba Chatterjee: This is possible through the information publisher or BI publisher reports. As for the CPU usage, the chart is available out-of-the box in the target page for hosts.

    How do you connect to the database itself when it’s hung and won't allow any extra connections? Do you use command line? Can you use ADDM even though the database is hung?

    Deba Chatterjee: When the database is hung, you can connect to it using the diagnostic connection mode in Real-Time ADDM. The agent that is used to monitor the database makes the connection. No, command line is used. You have to use Real-Time ADDM for the connection.

    Is Oracle Enterprise Manager 12c compatible with older versions of the database?

    Deba Chatterjee: You can use Oracle Enterprise Manager 12c to monitor Oracle Database versions: 9.2.0.8, 10.1.0.5, 10.2.0.4, 10.2.0.5, 11.1.0.7, 11.2.0.1, 11.2.0.2, and 11.2.0.3.

    Is SQL Performance Analyzer part of Oracle Database 11g or do you need to use Oracle Enterprise Manager 12c?

    Deba Chatterjee: SQL Performance Analyzer is built into the database and provides command line APIs. However, Oracle Enterprise Manager 12c provides the complete orchestration needed to capture the SQL tuning set, run the performance trials, and then to create a performance comparison report.

    How do you enable Enterprise Manager to monitor and send alerts to the DBAs for a "Runaway Query?”

    Deba Chatterjee: You can use EM to monitor runaway queries and send alerts using Metric Extensions which rely on the data captured in SQL Monitoring. The method was explained in this webcast presentation.

    How do you create a report for all the SQL running in an instance during a 30 minute timeframe? Can you export this to a spreadsheet?

    Deba Chatterjee: ASH stores sampled (1 seconds in memory or 10 seconds on-disk) SQL. However ASH is meant to capture the high load SQL statements so it won’t have all SQL statements.

    Do you recommend enabling automatic gathering of SQL baselines as a preventative measure of SQL regression?

    Deba Chatterjee: No. This would be overkill. Identify the queries that frequently change plans and then create SQL plan baselines.

    If a server has multiple database instances, what is the best way to effectively do resource allocation?

    Deba Chatterjee: There is no silver bullet. Carefully study your database load and decide on use of services, instance caging and resource managers to manage load on servers.

    When using SQL Performance Analyzer, do you create the baseline first before the code change is deployed or at peak DB time?

    Deba Chatterjee: These are two different problems. While testing for Code change, the baseline should be created before the code is deployed. While testing for an upgrade scenario the baseline needs to be created at a peak DB time.

    Is there a metric to monitor ASM disk group utilization at the cluster level?

    Deba Chatterjee: Yes. ASM Disk Group Usage metric is what you can use. (See image below)

    Can Oracle Enterprise Manager’s alerts be configured to monitor elements in the audit trail such as table creation or table drop?

    Deba Chatterjee: Yes, these type of alerts can be configured using Metric Extensions.

    LEARN MORE:

    Have a database manageability question? Ask us on Twitter or Facebook.


    Stay Connected:

    Twitter |
    Facebook | YouTube | Linkedin | Newsletter

    Download the Oracle Enterprise Manager Cloud Control12c Mobile app

    Friday Dec 21, 2012

    Oracle-validated NetApp Storage Plug-in for Enterprise Manager 12c

    The following is a Guest Blog, contributed by Anand Ranganathan, Product Manager for Oracle Products and Solutions at NetApp

    As a DBA managing databases running on storage systems, some of your major challenges are how do you:

    • Pinpoint storage related problems in a timely manner
    • Proactively respond to problems
    • Map a database file to its underlying storage component
    • Reduce your dependency on the storage admin
    • Solve these problems using an Oracle product that you use everyday

    If you are planning to or are currently running your Oracle databases on NetApp storage systems then the NetApp Storage System Plug-in for Oracle Enterprise Manager 12c resolves the above challenges by:

    • Consolidating information about Oracle on NetApp environments into the Enterprise Manager Cloud Control Console providing one interface to monitor databases and storage systems
    • Correlating and pinpointing storage related database problems by mapping database components like tablespaces, datafiles to storage components like aggregates, volumes using built-in reports and automating collecting a comprehensive set of availability, performance and usage metrics with pre-defined thresholds.  Alerts are automatically sent out when thresholds are breached helping you to respond proactively to problems before they occur.  You can also ensure routine responses to alerts are automatically executed using corrective actions
    • Increasing operational efficiencies by allowing you to standardize optimal Monitoring settings into a template and apply them to one or more NetApp Storage systems, report on historical metrics data for trend analysis & planning database storage needs, compare multiple storage system configurations to ensure they are deployed as per standards and prevent unnecessary alerts during scheduled downtimes with Blackout Periods

    The plug-in was built by NetApp using the Enterprise Manager 12c Extensibility Kit that not only helped us develop screens that have a rich look and feel but also helped enrich the plug-in by allowing us to leverage Cloud Control’s powerful monitoring and event management features for monitoring of NetApp storage systems. 

    The NetApp Storage System Plug-in for Oracle Enterprise Manager 12c is free and is listed at the Enterprise Manager Extensibility Exchange.  The plug-in has achieved Oracle Validated Integration, which provides customers the confidence knowing that it:

    • is designed and built in a reliable, standardized way
    • has been tested as functionally and technically sound
    • operates and performs as documented

    Here is a screenshot of the dashboard of a NetApp storage system monitored with Enterprise Manager 12c via the NetApp plug-in.



    Customers and partners can visit the NetApp Communities site to watch a demo and download the plug-in.  If you are a partner, visit the Oracle PartnerNetwork Validated Integration Knowledge Zone to learn more about the validation program.

    Wednesday Dec 12, 2012

    Heterogeneous Datacenter Management with Enterprise Manager 12c

    The following is a Guest Blog, contributed by Bryce Kaiser, Product Manager at Blue Medora

    When I envision a perfect datacenter, it would consist of technologies acquired from a single vendor across the entire server, middleware, application, network, and storage stack - Apps to Disk - that meets your organization’s every IT requirement with absolute best-of-breed solutions in every category.   To quote a familiar motto, your datacenter would consist of "Hardware and Software, Engineered to Work Together".  

    In almost all cases, practical realities dictate something far less than the IT Utopia mentioned above.   You may wish to leverage multiple vendors to keep licensing costs down, a single vendor may not have an offering in the IT category you need, or your preferred vendor may quite simply not have the solution that meets your needs.    In other words, your IT needs dictate a heterogeneous IT environment.  Heterogeneity, however, comes with additional complexity. The following are two pretty typical challenges:

    1) No End-to-End Visibility into the Enterprise Wide Application Deployment. Each vendor solution which is added to an infrastructure may bring its own tooling creating different consoles for different vendor applications and platforms.

    2) No Visibility into Performance Bottlenecks. When multiple management tools operate independently, you lose diagnostic capabilities including identifying cross-tier issues with database, hung-requests, slowness, memory leaks and hardware errors/failures causing DB/MW issues.

    As adoption of Oracle Enterprise Manager (EM) has increased, especially since the release of Enterprise Manager 12c, Oracle has seen an increase in the number of customers who want to leverage their investments in EM to manage non-Oracle workloads.  Enterprise Manager provides a single pane of glass view into their entire datacenter.  By creating a highly extensible framework via the Oracle EM Extensibility Development Kit (EDK), Oracle has provided the tooling for business partners such as my company Blue Medora as well as customers to easily fill gaps in the ecosystem and enhance existing solutions.  

    As mentioned in the previous post on the Enterprise Manager Extensibility Exchange, customers have access to an assortment of Oracle and Partner provided solutions through this Exchange, which is accessed at http://www.oracle.com/goto/emextensibility.  Currently, there are over 80 Oracle and partner provided plug-ins across the EM 11g and EM 12c versions.  Blue Medora is one of those contributing partners, for which you will find 3 of our solutions including our flagship plugin for VMware.  

    Let's look at Blue Medora’s VMware plug-in as an example to what I'm trying to convey.  Here is a common situation solved by true visibility into your entire stack:

    Symptoms
    •    My database is bogging down, however the database appears okay internally.  Maybe it’s starved for resources?
    •    My OS tooling is showing everything is “OK”.  Something doesn’t add up.

    Root cause
    •    Through the VMware plugin we can see the problem is actually on the virtualization layer

    Solution
    •    From within Enterprise Manager  -- the same tool you use for all of your database tuning -- we can overlay the data of the database target, host target, and virtual machine target for a true picture of the true root cause.

    Here is the console view:


    Perhaps your monitoring conditions are more specific to your environment.  No worries, Enterprise Manager still has you covered.  With Metric Extensions you have the “Next Generation” of User-Defined Metrics, which easily bring the power of your existing management scripts into a single console while leveraging the proven Enterprise Manager framework.

    Simply put, Oracle Enterprise manager boasts a growing ecosystem that provides the single pane of glass for your entire datacenter from the database and beyond. 

    Bryce can be contacted at info@bluemedora.com

    Wednesday Dec 05, 2012

    Enterprise Manager Extensibility Exchange – Version 1.1 Now Available!

    Since its announcement at Oracle OpenWorld 2012, the Enterprise Manager Extensibility Exchange is becoming the source to access Enterprise Manager entities, including plug-ins, connectors, deployment procedures, assemblies, templates, and more.  Based on feedback, the Exchange has recently been updated so Enterprise Manager administrators can find and access Oracle and partner-built plug-ins and connectors easier.




    The Exchange enables anyone to contribute an Enterprise Manager entity through the “Contribute” tab, where information about the entity is captured and placed on the Exchange once it is approved.  The Exchange encourages comment through the Enterprise Manager Forum. 



    An Oracle partner can build a plug-in by accessing the Extensibility Development Kit (EDK) found at the Development Resources tab.  Oracle partners and customers can can also engage a partner that has built its practice specializing in plug-in development and deployment.  One of those partners is Blue Medora, which has effectively used the EDK to build plug-ins to manage non-Oracle targets.  Check out the Blue Medora "Guest Blog" about heterogeneous datacenter management.

    Partners can also have their plug-ins validated through the Oracle Validated Integration (OVI) program.  NetApp is an example of a partner that recently built an Enterprise Manager plug-in and has validated it through the program.  Check their "Guest Blog" post describing the value of an Enterprise Manager "OVI" plug-in as well as discuss specifics the NetApp storage plug-in. 

    The Enterprise Manager Exchange is located at http://www.oracle.com/goto/EMExtensibility.

    Stay Connected:

    Twitter |  Facebook |  YouTube |  Linkedin |  Newsletter

    About

    Latest information and perspectives on Oracle Enterprise Manager.

    Related Blogs




    Search

    Archives
    « April 2014
    SunMonTueWedThuFriSat
      
    3
    5
    6
    7
    9
    10
    11
    12
    13
    14
    15
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
       
           
    Today