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.
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
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 (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.
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.
Oracle Enterprise Manager 13c Release 5 Update 3 (22.214.171.124), 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.
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
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
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.
• 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…
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