Oracle Enterprise Manager 13c Release 5 Update 3 (13.5.0.3) Is Now Available!

Oracle Enterprise Manager 13c Release 5 Update 3 (13.5.0.3), RU3 for short, is now available for download from My Oracle Support > Patches & Updates.

Release Updates Details

If you are new to the Enterprise Manager world you may find this information useful:  Release Updates (RUs) enable us to roll out new features and bug fixes quickly so you don’t have to wait for a new major release. Release Updates are versioned using a trailing digit indicating the RU version and are cumulative, which means that the most recent RU includes functionality from all previous Release Updates.  Our general recommendation is to apply the most current Release Update as soon as possible.

Read the complete article by Daniela Hansell

Compliance Dashboard on Engineered Systems

Oracle Cloud Infrastructure scores 78 percent in 2021 Gartner Solution Scorecard for IaaS and PaaS, showing continued momentum

Oracle Cloud Infrastructure (OCI) has again demonstrated strong growth, introducing hundreds of services and features over the past year. With all the challenges of a global pandemic, our teams continued to deliver on our product vision, and I’m both amazed and sincerely grateful.

Gartner® analyzes major cloud infrastructure providers in three reports: The 2021 Gartner Solution Scorecards for Integrated infrastructure-as-a-service (IaaS) and platform-as-a-service (PaaS), the 2021 Critical Capabilities for Cloud Infrastructure and Platform Services (CIPS), and the 2021 Gartner Magic Quadrant for CIPS. I’m happy to share the following results:

  • OCI scored 78% overall in 2021 Gartner Solution Scorecard for Oracle Cloud Infrastructure IaaS+PaaS, from 62% in 2020.
  • Oracle’s score for required criteria grew from 74% to 90%, including scores of 100% for Compute, Storage, Networking, and Software Infrastructure, such as Database as a Service and Functions offerings.
  • OCI scored better in all criteria and use cases in the 2021 Critical Capabilities for CIPS.
  • Finally, we grew in both “ability to execute” and “completeness in vision” in the 2021 Gartner Magic Quadrant for CIPS.

Read the complete article by Clay Magouyrk

Available now: SQL Tuning Advisor for Oracle Cloud Databases

SQL Tuning for maximizing Oracle Database performance 

Tuning usually implies fixing performance problems. However, tuning should be part of the life cycle of an application—through the analysis, design, coding, production, and maintenance stages. 

An important facet of database system performance tuning is the tuning of SQL statements. SQL tuning involves three basic steps:

•    Identifying high load or top SQL statements that are responsible for a large share of the application workload and system resources, by reviewing past SQL execution history from the system.
•    Verifying that the execution plans produced by the query optimizer for the statements perform reasonably.
•    Implementing corrective actions to generate better execution plans for poorly performing SQL statements.

Read the complete article by Sriram Vrinda

Building EM custom database monitoring dashboards for DevOps and other dedicated groups

Database monitoring is an art form developed with experience. Having custom dashboards based on specific enterprise or group-wide needs can make what was a task for a strong DBA more transferable. In this session, we covered how to quickly build and tune Oracle Enterprise Manager dashboards to meet your specific workflows. Scale experienced DBA’s knowledge by building appropriate dashboards to support newer DBA team members.

You”ll learn

• The advantages of custom dashboards

• How to set up dashboards designed for specific workflows

• How to share dashboards for group-specific tasks

Once these dashboards are setup, leverage the Enterprise Manager mobile app to get email alerts, and triage issues from the incident page. All from your phone.

The documentation for this can be found at: https://docs.oracle.com/en/enterprise…

Announcing support for Exadata monitoring in Performance Hub

Performance Hub for Exadata Overview

In this blog, we look at how to identify various performance issues using Performance Hub features for Exadata monitoring.

Performance Hub now has a new tab for Exadata. This tab provides a unified view of Oracle Exadata hard disk and flash performance statistics with deep insight into the health and performance of all components, such as the Oracle databases, Oracle Exadata storage cells, and Automatic Storage Management (ASM). You can use the Exadata tab for enhanced performance diagnostics for databases deployed on Exadata systems.

Please read the complete article by Sriram Vrinda

Oracle Enterprise Manager 13c Release 5 Update 2 (13.5.0.2) Is Now Available!

The second Release Update for Oracle Enterprise Manager 13.5!  Oracle Enterprise Manager 13c Release 5 Update 2 (13.5.0.2), RU2 for short, is now available for download from My Oracle Support > Patches & Updates.

Key Updates in RU2

This second update of EM 13.5 introduces new features designed to enhance the value and the overall customer experience with Oracle Enterprise Manager.  Here is a list of a few of these new features:

Enterprise Manager Dashboards

Dashboards allow you to visualize monitoring and management data in real time, enable you to monitor your enterprise at a glance, and simplify potential problems resolution.  With RU2, Enterprise Manager introduces out-of-the-box dashboards that provide a summary of the health, compliance status, grouping of your targets, and other details of your assets. The health and status data is organized, summarized and presented graphically as various widgets.  To further analyze and diagnose potential issues, you can drill down to more information from each widget. These dashboards can further be copied and customized as you see fit for your environment and your monitoring guidelines.

Read the complete article by Daniela Hansell

Exadata Insights in Oracle Cloud Infrastructure Operations Insights

Exadata Insights features

The OCI Operations Insights service enables business executives, database, and DevOps personnel to make informed, and data-driven compute resource and performance management decisions. With Operations Insights, you have the following capabilities:

  • Analyze resource usage of databases and hosts across the enterprise
  • Forecast future demand for resources based on historical trends
  • Compare SQL performance across databases and identify common patterns
  • Identify SQL performance trends across enterprise-wide databases

With the introduction of Exadata Insights, you can now analyze the resource utilization of the Exadata systems and identify the spare capacity for new workloads. This feature is available for Exadata systems that are managed by Oracle Enterprise Manager 13.5 RU01 and later.

Read the complete article by Sriram Vrinda

Announcing New Database Password Rotation with Oracle Enterprise Manager 13.5 RU1

In release EM13.5 RU1, EM has expanded automation for password rotation capabilities to include non-monitoring database users. In previous releases, password rotation automation was available only for the default database monitoring (dbsnmp) users using the job type “Change the Password for the Database Monitoring User”. The new feature is available using a new job type “Change the Password for a Database User”.

Since it is available as a job, this provides you flexibility in scheduling when and how often passwords should be changed. The job can be run against many databases at a time, greatly reducing the time it would take to complete the password rotation task. This is especially beneficial when working with hundreds or thousands of databases.

Read the complete article by Desiree Abrokwa

https://blogs.oracle.com/observability/post/announcing-password-rotation-enterprise-manager

Oracle Enterprise Manager 13c Release 5 Update 1 (13.5.0.1) Is Now Available!

Release Update for Oracle Enterprise Manager 13.5!  Oracle Enterprise Manager 13c Release 5 Update 1 (13.5.0.1), RU1 for short, is now available for download from My Oracle Support > Patches & Updates.

Release Updates Details

Some may recall, starting with the Enterprise Manager 13.4release, Release Updates (RUs) enabled us to more quickly roll out new features and bug fixes to customers – so you didn’t have to wait for a major release. Release Updates are versioned using a trailing digit indicating the RU version and are cumulative, which means that the most recent RU includes functionality from all previous release updates.  Our general recommendation is to apply the most current Release Update as soon as possible.

When was Oracle Enterprise Manager 13.5 introduced?

Earlier this year, we rolled out 13.5 as a major new release for our flagship management product. Oracle Enterprise Manager continues to be a leader in the data and infrastructure management space and with each RU, new capabilities continue to be added. Let’s look at what’s included in this RU.

Please read the complete article by Daniella Hansell

Announcing general availability of Oracle Cloud Infrastructure Application Performance Monitoring

The centerpiece of Oracle Cloud Infrastructure (OCI)’s integrated Observability and Management platform, OCI Application Performance Monitoring, is now generally available. It provides deep visibility into the availability and performance of applications and the ability to diagnose issues quickly to deliver a consistent level of service and user experience.

Oracle has been offering application performance monitoring solutions for well over a decade. These solutions include real user monitoring, service level management, and application management suites for on-premises infrastructure. But we’ve also offered a cloud solution since 2017. Combining these years of experience and working with partners and customers, we’re pleased to announce the general availability of our new OCI-native version of Application Performance Monitoring.

Read the full article by Daniel Schrijver