Mastering Oracle AI Database 23/26ai Innovations

The latest Oracle AI database 23/26ai brings major advances in AI, automation, performance, availability for MAA, security, and modern data management. These advancements provide database professionals (administrators, architects or engineers) with new ways to address everyday challenges in database management while meeting growing demands for performance, availability, security, and automation.

This book provides practical coverage of Oracle AI Database 23/26ai from deployment and patching to AWR, Oracle Machine Learning, blockchain tables, JSON and JSON Relational Duality, and SQL Macros. You will explore performance innovations including Automatic Indexing, SQL Plan Management, statistics, True Cache, In-Memory, ADO, tablespace optimization, priority transactions, and engineered systems. You will also learn Data Guard and standby automation, PL/SQL and REST API management, active replication, Active Data Guard, MAA, security, backup and recovery, data protection, masking, redaction, and database lifecycle management.

By the end of this book, you will be able to understand, deploy, manage, optimize, secure, and protect Oracle AI Database 23/26ai environments. The practical knowledge gained will help you apply modern Oracle capabilities to daily administration, architecture, automation, performance, and high-availability requirements.

WHAT YOU WILL LEARN
● Install and manage Oracle AI Database 23/26ai in different environments.
● Use Oracle Machine Learning and new AI capabilities.
● Monitor and improve database performance using advanced features.
● Work with JSON, blockchain tables, and SQL enhancements.
● Configure Data Guard, Active Data Guard, and MAA.
● Automate daily administration with scripts, PL/SQL, and REST APIs.
● Apply security, data protection, masking, and recovery techniques.

WHO THIS BOOK IS FOR
This book is written for database administrators, database and solution architects, engineers, developers, and IT professionals who work with Oracle AI Database. Readers with intermediate or advanced Oracle experience will find practical guidance for working with Oracle AI Database 23/26ai and using its new capabilities in their daily work. Beginners can also use the book to build their knowledge step by step and get good overview about all possibilities.

1. Introduction
2. AWR Enhancements
3. Oracle Machine Learning
4. Blockchain Tables
5. JSON Support Enhancements
6. JSON-relational Duality
7. SQL Macro
8. Patching
9. Performance Optimization
10. Automatic Indexing Optimization
11. Real-time SQL Plan Management
12. High-frequency Statistics Collection
13. True Cache
14. In-Memory Column Store
15. Automatic Data Optimization
16. Improved Tablespace Shrinking Operations
17. Priority Transactions and Graphs
18. Autonomous AI Database and Engineered Systems
19. Oracle Data Guard
20. Automatic Preparation of Standby Database
21. Performance Improvements in Data Guard
22. Broker Management and Data Guard Control Automation with PL/SQL
23. Exposing Data Guard as a Service REST APIs and Integration
24. Data Guard and Oracle GoldenGate for Active Replication
25. Oracle Active Data Guard
26. Exploring Maximum Availability Architecture
27. Security
28. Data Protection
29. Data Masking and Redaction
30. Database Lifecycle

Mariami Kupatadze is a senior solutions architect at FlashGrid Inc., where she has been helping enterprises design, deploy, and operate highly available Oracle Database infrastructures across public cloud environments since 2017. With more than 16 years of experience in database engineering and administration, she has worked with mission-critical systems for banks, government ministries, and enterprise organizations, building deep expertise in Oracle Exadata, Oracle Cloud, RAC, ASM, Data Guard, GoldenGate, high availability, disaster recovery, and related database technologies.


In 2016, Mariami became the first Oracle Certified Master (OCM) in Georgia - and remains the only one to date. She is also an Oracle ACE Alum and has been an active contributor to the international Oracle community for many years.


Mariami is an author and co-author of multiple books on Oracle technologies, including Oracle GoldenGate with Microservices, the 2026 book Mastering Oracle GoldenGate Microservices and more. She has also published technical articles in OraWorld magazine and the Oracle Technology Network, sharing practical knowledge gained from years of working with enterprise Oracle environments.


Since 2010, she has maintained her technical blog, dba010.com, where she shares solutions, troubleshooting experiences, tutorials, and lessons learned from real-world Oracle environments. The blog has been recognized among the Top 60 Oracle blogs and has served as a technical knowledge resource for Oracle professionals around the world.


Beyond her engineering work, Mariami has been actively involved in speaking, teaching, and knowledge sharing. She has spoken at international Oracle conferences and user-group events, including the APAC Oracle Users Groups Community (APACOUC) and the Luxembourg Oracle Users Group (LUXOUG). She has also lectured at universities and technology institutions in Georgia, including Business and Technology University, GRENA Cisco Academy, and International Black Sea University.


From 2019 to 2022, Mariami served as Director of FlashGrid Georgia LLC, alongside her role at FlashGrid. Earlier in her career, she held senior database engineering positions supporting critical systems in Georgia's banking and government sectors.


Her achievements have also been recognized beyond the Oracle community. In 2019, Mariami was recognized by Forbes Georgia's 30 Under 30 in the technology category. Her professional journey and achievements have since been featured in Forbes publications, and in 2024 she returned to Forbes Georgia as a jury member in the technology and e-commerce category, helping recognize the next generation of technology leaders.


Oracle has also highlighted Mariami's professional journey through its Spotlight on Success series, sharing her experience with Oracle certification, continuous learning, and the value that deep technical knowledge brings to organizations.


Throughout her career, Mariami has combined hands-on engineering, architecture, technical writing, teaching, and community involvement with a strong commitment to continuous learning.


Above all, however, Mari is most proud of being a mother to her two daughters, Salome Beridze and Ana Beridze, who remain her greatest source of inspiration and motivation both professionally and personally.



RNDr. Lucia Hustatyova, MBA is an enterprise and lead architect, Oracle Senior DBA, author of multiple Oracle technology books, and international speaker with almost two decades of experience in IT architecture, database engineering, automation, and enterprise data platforms. She is a triple Oracle Certified Master (OCM 10g, 11g, and 12c), an Oracle Exadata Certified Implementation Specialist, and holds several AI-related certifications across leading cloud platforms. In Slovakia, she is the first and remains the only woman to achieve the OCM certification.


Lucia holds a doctor of natural sciences degree in informatics (RNDr.), a master’s degree in mathematics and informatics (Mgr.), and an MBA in project management. Throughout her career, she has combined deep technical expertise with an architectural perspective, working with Oracle technologies across on premises environments, engineered systems, cloud platforms, and hybrid architectures.


Her experience spans Oracle Database administration, performance tuning, complex migrations and upgrades, patching, Data Guard, high availability and disaster recovery, backup and recovery, and data replication using Oracle GoldenGate Microservices Architecture. She is regularly involved in architecture design and consulting, implementation of new technologies, onboarding of enterprise customers, automation, and solving complex production challenges in mission-critical environments.


Lucia is the author of two books focused on Oracle GoldenGate, enterprise architecture, and high availability: MAA with Oracle GoldenGate Microservices in HUB Architecture and Mastering Oracle GoldenGate Microservices 23ai. Her books combine architecture and engineering principles with hands on implementation, automation, high availability, and experience gained from designing and operating Oracle environments in practice.


Automation plays an important role in Lucia’s work. She designs and develops solutions using scripting, programming, REST APIs, and infrastructure automation to simplify daily operations, improve consistency, and reduce the risk of human error. She is an active Oracle ACE and a participant in the Oracle Global Leaders program.


Her technical work, innovation, and contribution to the technology community have been recognized through several awards and distinctions. She was named UKOUG Speaker of the Year in 2025 and received the Oracle Global Leader Champion 2025 recognition. During her professional career, she has also been recognized as Best Skiller in 2020, Best Innovator in 2020, and Best Specialist in 2023. For her extraordinary work and contribution beyond her immediate organization, she has twice received a Best Performer recognition at global company level in an organization with approximately 200,000 employees.


Lucia actively contributes to the Oracle community through technical writing, knowledge sharing, and speaking at international conferences and universities. She has presented across Europe, the United States, the Middle East, and Africa, including Las Vegas, Paris, London, Vienna, Germany, the Czech Republic, Slovakia, Morocco, Egypt, and Dubai. She was also nominated for the Žena v IT 2026 (Woman in IT 2026) award in Slovakia, recognizing women for their achievements, innovation, leadership, and contribution to the technology sector.


Beyond her professional work, Lucia is passionate about sharing her experience, supporting the technology community, and encouraging more women to pursue and develop careers in IT. Above all, she is a proud mother of three children, twins Alexander and Viktoria, and Simona and is actively involved in their education, school activities, and demanding competitive sports schedules. Balancing family life with a career in technology has reinforced her belief in continuous learning, discipline, persistence, and good organization, both professionally and personally.