Oracle Database 19c represents a dedicated and enduring support release, prioritizing optimal performance, scalability, reliability, and security across operational and analytical workloads. The primary focus of version 19c is on stability, laying the groundwork for forthcoming autonomous database enhancements. Notable among these enhancements is the database's capacity to autonomously generate indexes, fostering self-optimization and sustained optimal configuration.
Furthermore, Oracle Database 19c introduces advancements like real-time statistics for all operations and the automatic isolation of problematic SQL queries. It also presents distinctive innovations tailored for core enterprise functions. Noteworthy for users with standby databases, Oracle 19c allows updates to these standbys, transforming them from read-only to read-mostly assets. To address streaming data and accommodate Internet of Things (IOT) workloads, 19c introduces a new in-memory row store and API, delivering exceptionally high-speed and high-volume data ingestion capabilities.
Why 19c?
Across consecutive releases, Oracle has introduced cutting-edge automated functionalities empowering administrators to deliver an elevated level of service to end users. These advancements encompass:
- Cost-Based Optimization, encompassing automatic SQL query optimization, automatic statistics gathering, automatic query rewrite, automatic SQL Plan management, and automatic SQL tuning.
- Performance Tuning and Diagnostics, including automatic memory and resource management, automatic index and materialized view advisors, Automatic Database Diagnostic Monitor, Automatic Database Workload capture & replay, and Automatic Workload Repository.
- Data Optimization, covering automatic undo management, automatic segment space management, Automatic Storage Management, Automatic Data Optimization, and automatic columnar cache.
- Cloud-Scale Operation, featuring Automatic standby management (broker), Diagnostic Framework, Multitenant Architecture, automatic database clone refresh, and machine learning in Cluster Health Advisor.
MULTITENANT ARCHITECTURE
Tailored for cloud deployment, whether public or private, Oracle's multitenant database boasts a distinctive architecture that streamlines consolidation, offering the high density characteristic of schema-based consolidation without necessitating alterations to existing applications. This architecture revolves around a single multitenant container database (CDB) capable of accommodating numerous 'pluggable' databases (PDBs). Each database that is consolidated or 'plugged in' to a multitenant container presents the same look and feel to applications as pre-multitenant Oracle databases. The consolidation into a multitenant container facilitates the sharing of container memory and processor resources among multiple pluggable databases, elevating the level of database consolidation density. Furthermore, within a CDB, all PDBs are effectively "managed as one" for tasks such as database backup, patching, upgrading, and standby operations.
Oracle's multitenant database introduces enhanced administrative agility, facilitating swift database provisioning and online operations. Key capabilities include:
- • PDB Hot Clone, enabling rapid instantiation of PDBs without disrupting users.
- PDB Refresh, allowing cloned PDBs to be regularly updated with the latest data.
- • PDB Relocate, permitting the relocation of PDBs between CDBs with minimal downtime.
Additionally, the Application Container features of Oracle's multitenant database enable the transformation of applications, originally designed for standalone deployment on-premises, into an instant Software-as-a-Service (SaaS) architecture without any code modifications. The application is installed unchanged into an Application Root, and tenant PDBs, serving separate customers, can share the application code while maintaining secure isolation of tenant data. Application upgrades are applied solely to the single Application Root master, with tenant PDBs seamlessly synchronizing with the upgraded master.
Widely embraced by both Independent Software Vendors (ISVs) and customers, Oracle's multitenant database finds deployment in on-premises and Cloud environments alike. Several Oracle Cloud Database Services, including the Autonomous Database Cloud, rely on multitenant capabilities for tenant isolation, agility, and scalability. Oracle Database 18c introduced numerous enhancements to multitenant functionality.
Use Hyperconverged Infrastructure
The rapidly advancing realm of hyperconverged infrastructure (HCI) holds the promise of numerous technical and financial advantages. The market has swiftly acknowledged and affirmed the merits of HCI, which amalgamates the key components of a three-tier architecture – compute, storage, and networking – into a unified solution. The presence of high-quality, vendor-supplied software is paramount for ensuring the effortless and effective management of resources. HCI solutions, beyond overseeing the essentials of compute, storage, and networking layers, encompass features for Disaster Recovery (DR) and the capability to seamlessly scale up by adding additional nodes as needed.
From a technical optimization standpoint, Oracle customers stand to gain several advantages from HCI. This includes the reduction of unused hardware capacity through improved resource management, the elimination of network devices, and the ease of scaling up Oracle deployments swiftly and efficiently in response to escalating demand. The process of adding nodes and migrating workloads becomes a seamless operation.
Cisco HyperFlex systems and RAC
Oracle Databases and Real Application Clusters (RAC) serve as the cornerstone for numerous enterprise applications, encompassing online transaction processing (OLTP), data warehousing, business intelligence, report generation, and online analytical processing (OLAP). As the volume and diversity of data grow, the demand for adaptable and scalable systems with consistent performance becomes crucial to manage database sprawl. Leveraging Cisco HyperFlex equipped with All Flash or All NVMe nodes offers a flexible platform for running Oracle Database and RAC deployments, facilitating faster insights at a reduced cost.
Key attributes of Cisco HyperFlex systems in conjunction with Oracle Database and RAC include:
- Alignment with the specific requirements of databases and applications
- Reduction in storage footprint
- Optimization of storage costs
- Provision of predictable database performance
- Ensuring the availability of enterprise applications and databases
Summary
The article highlights the key features and benefits of Oracle Database 19c, emphasizing its focus on stability and autonomous database enhancements. It introduces notable advancements, such as autonomous index generation, real-time statistics, and automatic isolation of problematic SQL queries. The piece also delves into Oracle's multitenant architecture, detailing its advantages for cloud deployment, administrative agility, and application container capabilities. The use of hyperconverged infrastructure (HCI) is recommended for technical optimization, offering advantages like reduced hardware capacity, simplified management, and efficient scaling. Additionally, Cisco HyperFlex systems are presented as a solution for running Oracle Database and Real Application Clusters (RAC), ensuring flexibility, reduced costs, and predictable performance.
Resources:
Cisco HyperFlex All-NVMe Systems for Oracle Real Application Clusters: Reference Architecture
Deploy a High-Performance Standalone Oracle Database Solution: Oracle 19c on Cisco UCS X-Series
