Exadata System Software Release 18.104.22.168.0 is now generally available.
This release follows Exadata System Software Release 20.1 and brings further innovations to performance and manageability of the Exadata fleet, making the platform even more predictable in high performance settings, and even more scalable for consolidation environments. Making everything easier with Exadata!
The past year has been an unprecedented time for all, affecting our customers globally, who are expected to do more remotely. With the Exadata 21.2 release, we have focused on manageability and performance, both of which drive towards managing increased workloads with the same or fewer resources.
Our unique Exadata software allows us to ensure your investment continues performing at the peak of productivity. As mentioned when we released Exadata Software 20.1, "We continue our tradition of protecting your investment in Exadata, with all new software features compatible across RoCE and InfiniBand systems, and all supported Exadata hardware generations”.
Exadata Product Management is happy to state this tradition has not changed with the Exadata Software 21.2 release.
In this post, we outline some of the enhancements in Exadata Software 21.2, for more information you can visit the Exadata System Overview Guide.
Most people familiar with Exadata realize the importance of Storage Indexes in avoiding unnecessary I/O from/to the Storage Servers. To recap, Storage Indexes are automatically created to track and maintain min/max values. These indexes are held in ephemeral memory of each Storage Server and are used by data warehouse and analytic workloads to eliminate and avoid IO. New in Exadata 21.2 - Storage Indexes will be persisted on the local disk to avoid rebuilding the storage index after planned maintenance or unplanned downtime. Eliminating the cycles to rebuild Storage Indexes, after server restarts, ensures application performance remains consistent.
Columnar cache is a portion of Exadata Smart Flash Cache that contains data in columnar format. As part of query performance tuning, data in Exadata Smart Flash Cache is automatically converted and stored in columnar format in this cache. New in Exadata 21.2 - If a storage server running in Write-Back mode is shutdown (either gracefully, via upgrades, or due to other failures), the columnar cache will persist, enabling more consistent query performance immediately after a Storage Server restart.
I/O Resource Management (IORM) is a powerful tool that enables user-defined policies to be assigned to workloads and databases to share Oracle Exadata Storage Servers resources reducing the incidence of "noisy neighbor" impacts to critical databases. New in Exadata 21.2 - Database Machine Administrators are now able to allocate storage resources based on cluster boundaries, rather than individual database or consumer groups. This allows for more flexible and holistic resource allocation. By defining the plan at the cluster level, any database (existing or new) in a cluster inherits the I/O plan of that cluster. Ensuring new databases created without a specific plan do not overrun existing database workloads.
A foundational feature of Exadata Storage Software for analytic workloads is the Smart Scan operation. When Oracle Databases send queries to the Exadata Storage tier, associated metadata is also sent. Query metadata contains information such as projected columns, predicates, session information, bloom filters, and other information. This information is key to driving the query offload to the storage server. New in Exadata 21.2 - Rather than each Parallel Query packaging the metadata for each execution, common query metadata is shared across Smart Scan sessions belonging to the same parallel query. This reduces individual parallel query processing on the storage server thereby increasing the overall system throughput. Best seen in the more sophisticated operations with large amounts of metadata such as data mining, JSON/XML type tables and joins with bloom filters.
Other additional features of Exadata Software 21.2 include:
More information on Exadata System Software Release 21.2 can be found in the New Features for Oracle Exadata System Software Release 21.x section in the Oracle Exadata System Overview Guide.
Exadata System Software Release 21.2 is the best upgrade target for customers who want to move to Oracle Linux 7.
New Exadata systems will ship with Exadata System Software 21.2 in the coming weeks. Customers upgrading from previous software releases can refer to My Oracle Support Note 888828.1 which provides the minimum set of Grid Infrastructure and Database Software versions and patches needed to update to Exadata System Software Release 21.2. (Or just talk to Oracle Platinum Services to take care of it for you!)
A big thanks to our Exadata Development team who continue to provide these new features to enhance the Exadata platform.
We are always interested in your feedback. You are welcome to engage with us via comments here.