Each month, Oracle ACEs worldwide share their expertise with the community, contributing hundreds of insightful blog posts, articles, podcasts, and technical deep-dives. This August, we’ve curated a standout selection focused on the latest Oracle Database topics—from new features and best practices to automation, backup strategies, and more. Whether you’re looking for tips on cloud connectivity, performance optimization, or cutting-edge storage technologies, these highlighted posts are packed with knowledge to help you stay ahead.
Arsalan Dehghani Sariyarghan – Leveraging Oracle Database Smart Flash Cache for Optimal Performance
The Oracle Database Smart Flash Cache is a powerful feature that dramatically boosts database performance. Its tools are not vastly different from the regular equipment used with a database, but the cunningly smart decisions made by this feature are what really count. Read more.
Bobby Curtis – Real-Time Oracle Database to Google BigQuery: A GoldenGate 23ai How-To Guide
For data engineers and architects, enabling real-time data flow from transactional Oracle databases into analytical platforms like Google BigQuery is a crucial task. This guide outlines the technical configuration steps for achieving this with Oracle GoldenGate 23ai, focusing on the core components and their specific settings for robust, high-performance replication. Read more.
Bugra Parlayan – Best Practices for Very Large Database (VLDB) Backup and Recovery
Backing up and recovering Very Large Databases (VLDBs) presents a critical yet increasingly complex challenge for organizations in today’s data-driven world. With data volumes growing exponentially, traditional backup methods often fall short in meeting performance targets, Recovery Time Objectives (RTOs), and Recovery Point Objectives (RPOs). Read more.
Christian Pfundtner – Oracle AutoUpgrade 25ai New Features
AutoUpgrade 25ai—25.3 was available at the time of this article—brings in some interesting new features. Most of them relate to improvements to the automatic installation of out-of-place homes, which has been available since AutoUpgrade 24.7. Read more (article in German).
Jone Jarouj – Duplicate Database For Standby From Active Database
In this article, we will create a data guard standby database using RMAN active database. For this, we need to configure both servers, primary and secondary, with the listener.ora and tnsnames.ora files, ensuring cross-connections between the servers. This setup allows the primary server to access the database on the secondary server and vice versa. Read more.
Lida Gholizadeh – Create a Database in Oracle Cloud and Connect to it by Using SQL*Plus and SQL Developer
How to Create a Database in Oracle Cloud and Then Connect to it by Using SQL Developer and SQL*Plus? Read more.
Maicon Carneiro – How to Monitor the Available Space on Exascale Storage Vault using SQL Query on Oracle Database 23ai
The new and revolutionary architecture of Exadata, named Exascale, comes with a lot of new things that every Oracle DBA should learn to leverage the power of Oracle Database 23ai running on Exadata systems. One of the most significant and notable difference that any DBA should notice at first time working with Exascale, is the fact that ASM is not used anymore. Read more.
Miguel Anjo – Encrypt the whole Oracle database online with TDE
Some programs are part of Oracle ISV – Independent Software Vendors – program and include various types of Oracle licenses. This allows to install the application database in various Oracle configurations. At my customer, the software includes Advance Security Option Oracle license. This was the reason we decided, even before moving to the cloud, to encrypt the database. Read more.
Saravanan Mahalingam – Automating Oracle Database Patching with Ansible: A Complete Guide
Oracle database patching has long been the bane of DBAs everywhere. It’s a critical task that requires precision, expertise, and often results in extended maintenance windows. What if I told you that you could automate this entire process, reducing both risk and downtime while ensuring consistency across your Oracle estate? Read more.
Tim Hall – Dynamic Statistics for PL/SQL Functions in Oracle Database 23ai
Using PL/SQL functions in SQL statements can be convenient, but it makes it difficult for the optimizer to estimate the cardinality of operations, which in turn may impact on the choice of execution plan. One method the optimizer can use to improve the cardinality estimate is to use Dynamic Statistics. In simple terms it runs the statement to find out the real cardinalities. Read more.
We hope you find these ACE-curated resources valuable as you continue to innovate and manage your Oracle environments. You can find all the ACEs above and many more in the Oracle ACE Directory. Bookmark the Oracle ACE Program blog and come back next month for more updates!