Quickly Monitor and Manage Databases with a Cloud Service

For DevOps, developers, DBAs, and IT team members looking for a quick and robust way to monitor and manage databases, these highlights from a technical session may be good news. Oracle experts describe top uses for Oracle Cloud Infrastructure Database Management Service and specifically around managing databases in a multicloud or hybrid cloud environment using a cloud-based solution. This session was part of Oracle Observability and Management at Oracle Database World and this session can be found here.

Read the complete blog article by Timothy Mooney

Oracle Private Cloud Appliance X9 delivers cloud portability for developing and deploying diverse workloads

Customers challenged with migrating to the cloud or implementing hybrid cloud strategies will find Oracle’s new Private Cloud Appliance to be a compelling solution. Oracle Private Cloud Appliance X9-2 (PCA X9-2) uses infrastructure APIs and management tools that are compatible with Oracle Cloud Infrastructure (OCI) to enable customers to design, develop, and operate applications and middleware using architectures and tools that are consistent across both a private and public cloud. PCA X9-2 allows customers to rapidly develop and deploy new applications using cloud-native capabilities and run existing enterprise applications with multiple operating systems on scalable infrastructure in their data centers.

Read the complete article by Bill Jacobs

Testing Best Practice Before and After Your Database Upgrade or Migration

Too often you or a team member have the best intention to test and QA before production, yet a duplicate system or production data is not available. With a production milestone date looming, a last-minute scramble locates an environment and some data, and a test is performed. So, is it really ready for production? Later, a tragic story unfolds, with the production rollout negatively impacting customers, team members working overtime to restore service, and later executive management asking for a post-mortem.

Read the complete article by Steve Lemme

Application Performance Monitoring: Instrument Java on Kubernetes for Monitoring and Diagnostics

Application Performance Monitoring (APM), an Oracle Cloud Infrastructure (OCI) native service, enables DevOps engineers and application administrators to monitor end-users experience and application performance by tracing and correlating transactions through multiple components and application logic distributed across various clients, third-party services, and backend tiers, in the Cloud or on-premises.

With applications running as a container in Kubernetes it can be difficult to understand what is happening when the applications do not perform as expected. The container orchestration frameworks such as Kubernetes introduced new scalability and fault tolerance capabilities but made the data flow through the application components less transparent.

For microservices-based applications developed for an open-source Java-based framework – example Spring Boot, Java agents can provide automatic instrumentation and deep insight into the internals of the application.

Read the complete article by Daniela Hansell

Oracle Database World – The Observability Perspective

Oracle Database World has been making the rounds around the world since October 2021. It’s a virtual event repeated for regions worldwide. This event offered a comprehensive deep dive for Oracle’s database technologies. Juan Loaiza and Andy Mendelsohn, along with many top architects and experts presented Oracle’s latest innovations, best practices, and tips. Overall, there were 99 technical sessions and 24 hands-on labs covering technologies including Autonomous Data Warehouse and Data Lake, Exadata Cloud@Customer, Database 21c, and more.

Read the complete article by Moe Fardoost

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